We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now


unable right mouse click

msgek asked
Medium Priority
Last Modified: 2008-01-16

I have made toolbar in Excel. All build_in toolbar have been disabled.  But if user click my toolbar with right mouse, he can still set them back. How can I disable right_mouse_click function?

Using VBA? or  API?

Help Please!!!!

Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
When you right-click over the toolbars or the menu, the appearing shortcut-menu is a commandbar called "Toolbar List". You can disable it with:

CommandBars("ToolBar List").Enabled = False

This will Not work for Excel versions prior to 97 SR1.
(bugg fixed in 97 SR1)

Hope this will help.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.