Identify when a user attempts to turn on "Allow cell drag and drop"
Hi All,
I have a workbook where we have disabled "Allow cell drag and drop".
I would like to be able to stop users from re-enabling it manually
from the Tools - Options menu.
Is that possible?
I know I can disable it using VBA by the following line:
Application.CellDragAndDrop = False
My problem is that I don't know when it has been changed manually by a
user?
I guess I actually either one of:
1) Stop it happening by disabling it entirely so users cannot
re-enable OR
2) Catch the re-enabling 'event' and trigger code that re-disables it
immediately.
Thanks for any suggestions.
Alan.
|