Disable Shortcut Keys
 

I have disabled all menu, tool and command bars but one
can still use shortcut keys. I am looking for a way to
disable the shortcut keys for a workbook and then enable
them on close.

Any help is very much appreciated.

Disable Shortcut Keys
 

Ronbo,

You'd have to use Application.OnKey for each of the shortcut keys
you want to disable.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Ronbo" wrote in message
...
I have disabled all menu, tool and command bars but one
can still use shortcut keys. I am looking for a way to
disable the shortcut keys for a workbook and then enable
them on close.

Any help is very much appreciated.