lock customize bar

D

Daniel

I built my own Menu Bar and use:
Application.CommandBars("Standard").Enabled = False
to avoid unwanted changes. But right click on menu bar still let users
to add buttons and customize it.
Any help on how to get rid of "customize" option, or at least lock it
out.
Thanks!
 
J

Juan Pablo Gonzalez

You can use the .Protection property to decide what you want the users to do
or not to do with the commandbar.
 
Top