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." <(E-Mail Removed)> wrote in message
news:CA711AB0-4F03-4CD2-B018-(E-Mail Removed)...
> 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.
>