View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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