View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JON-JON JON-JON is offline
external usenet poster
 
Posts: 14
Default How to disable Keyboard shortcut

Hello VB Experts,

I am the same person that recently post a problem about BeforePrint Event. I
get away with that problem. What I did is to put this code to my open
event.

For Each bar In Application.CommandBars
bar.Enabled = False
Next bar

My problem now is how to disable keyboard shortcut (e.g. ctrl+o) so that
what will be left for my user is my macro that I plan to assign to an
embedded object.

BTW - Thanks to those who care to help sp. William and Tom

Thanks again in advance!

Jon-jon