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.
 
Commandbars("Toolbar List").Enabled = False

Works in Excel 97 SR1 and later
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing options on excel standard right-click menus 1
add "paste values" to right click menu 6
Right-Click (Context Menu) 6
Context Menu 2007/2010 19
How to remove stuff that appears when I click on the windows button on the bottom left of my screen? 2
Submenus on Shortcut Menus 2
right click menu 1
Custom right-click menu without changing Excel.App 1

Back
Top