Disabling Shortcut Hot Keys
 

Hello.

I would like to temporarily disable the shortcut key for Print for a
worksheet and then restore it for the other worksheets.

I have already successfully diabled the CommandBar and the ToolBar. I
also want to be able to disable the Print (Ctrl + P) key strokes and
then restore it.

Can anyone help?

Thanks,

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Disabling Shortcut Hot Keys
 

Check out Application.Onkey in the VBA help Dan

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Dan Gesshel" wrote in message ...
Hello.

I would like to temporarily disable the shortcut key for Print for a
worksheet and then restore it for the other worksheets.

I have already successfully diabled the CommandBar and the ToolBar. I
also want to be able to disable the Print (Ctrl + P) key strokes and
then restore it.

Can anyone help?

Thanks,

Dan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!