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.