ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deactivate shortcut keys in excel.. (https://www.excelbanter.com/excel-programming/343757-deactivate-shortcut-keys-excel.html)

areddy[_8_]

Deactivate shortcut keys in excel..
 

Hi All,

i want to deactivate the shortcut keys in Excel file. Means if i press
Ctrl+N new excel file will open and if i press Ctrl+O means open window
will display.

That should not happened when i press Ctrl+N or Ctrl+O with the
shortcut keys that should restrict with code or any option.

Is there any code to disable shortcut keys operation.

Please any one help on this one.

Thanks&Regards,
Amar..


--
areddy
------------------------------------------------------------------------
areddy's Profile: http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=479029


Norman Jones

Deactivate shortcut keys in excel..
 
Hi Areddy,

See the Onkey method in VBA help and see the accompanying examples.

---
Regards,
Norman



"areddy" wrote in
message ...

Hi All,

i want to deactivate the shortcut keys in Excel file. Means if i press
Ctrl+N new excel file will open and if i press Ctrl+O means open window
will display.

That should not happened when i press Ctrl+N or Ctrl+O with the
shortcut keys that should restrict with code or any option.

Is there any code to disable shortcut keys operation.

Please any one help on this one.

Thanks&Regards,
Amar..


--
areddy
------------------------------------------------------------------------
areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=479029





All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com