Menu Bars

[Kevin McCartney]

Hi
I'd like to set several properties of a menu bar to false, the properties are

Show on Toolbars Men
Allow Customizin
Allow Resizin
Allow Movin
Allow Show Hidin

I expect the code to be something lik

Application.CommandBars("mytoolbar").Property("Show on Toolbars Menu") = Fals

but can not find an example in the help, can anyone tell me what the code should look lik

TI
cia
KM

 

[Van T. Dinh]

Application.CommandBars("MyToolBar").Enabled = False
Application.CommandBars("MyToolBar").Protection = msoBarNoCustomize + _
msoBarNoResize + msoBarNoMove + msoBarNoChangeVisible

Make sure you add the Office Object Library into the References of your
application. Otherwise, you need to replace the above symbolic constants
with the explicit values.