Copy disable
Hello,
Is it possible to disable the copy function as set ctrl-c or in the edit pulldown menu. Stefan |
Copy disable
Hi Stefan,
Yes, the command is: Application.CommandBars("Worksheet Menu Bar").Controls("Edit").Controls("Copy").Enabled = False HTH Carim |
Copy disable
I'll admit ignorance on the subject of disabling it in the drop down menu,
but you should be able to disable the ctrl+c function by directing that hot key to a sub that does nothing. Example sub workbook_open () application.onkey "^{c}", "Idonothing" end sub sub Idonothing () end sub -- When you lose your mind, you free your life. "Stefan Buijs" wrote: Hello, Is it possible to disable the copy function as set ctrl-c or in the edit pulldown menu. Stefan |
Copy disable
You can disable the copy by simply adding a selectionchange event macro. The
macro does not have to day anything but it will keep the user from being able to copy. HTH "Stefan Buijs" wrote: Hello, Is it possible to disable the copy function as set ctrl-c or in the edit pulldown menu. Stefan |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com