disable right mouse click on "Worksheet Menu Bar"
 

HI

I would like to disable the right mouse click on the "Worksheet Menu Bar",
so that you can't add other toolbars such as Standard, Formatting etc..
Unfortunately I couldnt find this in the VBA Help

Hoping someone can help

Max Potters

disable right mouse click on "Worksheet Menu Bar"
 

Hi Max

Try this

Application.CommandBars("Toolbar List").Enabled = False


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Max Potters" wrote in message ...
HI

I would like to disable the right mouse click on the "Worksheet Menu Bar", so that you can't add other toolbars such as Standard,
Formatting etc.. Unfortunately I couldnt find this in the VBA Help

Hoping someone can help

Max Potters

disable right mouse click on "Worksheet Menu Bar"
 

unfortunately, double-click still is accessible.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ron de Bruin" wrote in message
...
Hi Max

Try this

Application.CommandBars("Toolbar List").Enabled = False


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Max Potters" wrote in message
...
HI

I would like to disable the right mouse click on the "Worksheet Menu
Bar", so that you can't add other toolbars such as Standard,
Formatting etc.. Unfortunately I couldnt find this in the VBA Help

Hoping someone can help

Max Potters