Removing the right click capability

  • Thread starter Thread starter Richard m
  • Start date Start date
R

Richard m

I have created code to create special menus and they work fine. But ho
do I keep the right click menu from appearing when you right click th
main menu?

Can this be done and how
 
If you are catching the BeforeRightClick event you can set the Cancel
argument to True (Cancel = True) which will tell Excel not to continue
processing the RightClick event.
 
Rob,

I put this in the worksheet code and it kept the right click memu from
showing. But my problem is to the cancel the right click menu when I
right click the main menu bar or any of the other tool bars.
 
Thanks Tom,

This helps me start a great New Year. Just one thing for others,
remember to set it true in the deactivate sub or you will not get your
right click back.
 
Back
Top