Diasable Fill function
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. |
Diasable Fill function
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. |
Diasable Fill function
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. |
All times are GMT +1. The time now is 12:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com