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.

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"YY san." wrote in message
...
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.

Hi,

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

--
Thanks,
Shane Devenshire


"YY san." wrote:

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.