disable right mouse click on "Worksheet Menu Bar"

[Max Potters]

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

 

[Ron de Bruin]

Hi Max

Try this

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

 

[Bob Phillips]

unfortunately, double-click still is accessible.

--

HTH

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