Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Diactivate shortcut keys
Hi
Thanks in advance. Is there a way to diactivate the keyboard shortcuts while a specific workbbok is open, so that if the user press e.g. Ctrl+C it would not work. Thanks. Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Diactivate shortcut keys
"Uddinj1" wrote in message
... Is there a way to diactivate the keyboard shortcuts while a specific workbbok is open, so that if the user press e.g. Ctrl+C it would not work. Thanks. You can use Application.OnKey to do this. Run the following line when your workbook opens, either in the Auto_Open procedure or Workbook_Open event: Application.OnKey "^c", "" This disables Ctrl+C copying. To enable it again when your workbook closes add the following line to the Auto_Close procedure or Workbook_BeforeClose event: Application.OnKey "^c" -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Diactivate shortcut keys
Look in the Excel VBA help for SendKeys. It tells you how to do that. You
would have to put the appropriate code in the workbook level activate and deactivate events. -- Regards, Tom Ogilvy "Uddinj1" wrote in message ... Hi Thanks in advance. Is there a way to diactivate the keyboard shortcuts while a specific workbbok is open, so that if the user press e.g. Ctrl+C it would not work. Thanks. Regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortcut Keys | Excel Discussion (Misc queries) | |||
Shortcut Keys ? | Excel Discussion (Misc queries) | |||
shortcut keys | Excel Discussion (Misc queries) | |||
Shortcut Keys | Excel Programming | |||
Shortcut Keys | Excel Programming |