Dragging Cell Contents

[xl_psychic]

Hi,

Im back with my queries. This time around its a bit different. Or it might be one of the common ones on the board. In my workbook, I have prevented the user from Copying/Cuting data. However there are cells which are meant for input purpose and hence not locked. I am facing a #REF problem whenever the user drags the contents of such cells.

Is there any way to prevent the user from doing the same.

(OS: WinXP, Excel 2000)

 

[xl_psychic]

Thanks Andrew... The code works just perfect... I have also reversed the same in the Worsheet_Deactivate procedure. One thing i wanted to ask was if the user is on the sheet in which the code resides and he saves the file will his Excel application be affected (as in other workbooks and Excel files that he will open after saving this one)

Please let me know and thanks once again for all the help.

 

[Andrew Poulsom]

Have you tried it?

The Worksheet_Deactivate event procedure does not fire if you close a workbook, so you need to reset the property in the Workbook_BeforeClose event procedure.

By the way, what happens if the user's preference is to disable cell drag and drop? You should not set it to True unless that's what the user wants. You should store the user's setting somewhere (in a static variable or on a worksheet) and set it back to what it was.

 

[xl_psychic]

i dont want the user to save his/her preference. The reason for me entering this code is to save myself from the hassles of dealing with the #REF!. I'll insert the code in the workbook_beforeclose event procedure and try....

Thanks for the help...