merlin_the_magician
Active Member
- Joined
- Jul 31, 2002
- Messages
- 480
I have a worksheet in which i disabled CutCopyMode and CellDragAndDrop functions through VBA in order to prevent users from messing up the sheet.
Code is simple and looks like this:
With Application
.CutCopyMode = False
.CellDragAndDrop = False
End With
Works lovely, unfortunately just a little to much... after closing the workbook the functions remain disabled.
How can I re-enable these functions on exit of the workbook, and where shoud i put the code?
With Application
.CutCopyMode = False
.CellDragAndDrop = False
End With
Code is simple and looks like this:
With Application
.CutCopyMode = False
.CellDragAndDrop = False
End With
Works lovely, unfortunately just a little to much... after closing the workbook the functions remain disabled.
How can I re-enable these functions on exit of the workbook, and where shoud i put the code?
With Application
.CutCopyMode = False
.CellDragAndDrop = False
End With