Removing the right click capability

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
 
R

Rob van Gelder

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.
 
R

Richard m

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.
 
R

Richard m

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.
 
Top