Diasable Fill function

Y

YY san.

Hi,
I have a macro to disable copy and paste function. However, I realised that
I could still use Fill function(drag and fill) to "copy" the value.
Appreciate if anyone can help me with a macro that will disable the Fill
function.
Thank you so much.
 
B

Bernard Liengme

Drag and drop can be turned on/off from the Options dialog (Edit tab)
I recorded a macro and got the code

Sub Macro1()
Application.CellDragAndDrop = False
End Sub

Of course, you should use an event macro to turn this feature back on when
the file is closed.
best wishes
 
S

ShaneDevenshire

Hi,

Don't forget to disable the right-mouse command, and the toolbar buttons,
and the shortcut keys.
 
Top