View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 188
Default 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.