View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
 
Posts: 226
Default lock customize bar

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

--
Regards,

Juan Pablo González

"Daniel" wrote in message
om...
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!