Diasable Fill function

[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.

 

[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

 

[ShaneDevenshire]

Hi,

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