View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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!