PDA

View Full Version : Solved: Hide custom CommandBar form Popup Menu



Adamski
02-03-2010, 10:38 AM
Hello,

How can I hide my commandBars from the popup menu you get when right clicking a CommandBar. I ideally don't want users to be able to hide My CommandBar.

Set cbr = CommandBars.Add("TestBar", msoBarRight, , True)

Thanks.

Bob Phillips
02-03-2010, 03:13 PM
You could disable the Customize control, or maybe have amn Ontime loop setting it up (putting it back).

Adamski
02-04-2010, 04:29 AM
This did the trick:
cbr.Protection=msoBarNoCustomize+msoBarNoChangeVisible
Cheers for pointing me to disable customize

Bob Phillips
02-04-2010, 04:33 AM
Nice one. I like that and will probably use it myself.

Bob Phillips
02-04-2010, 04:37 AM
It is a pity that only the top-level has this protection property, it means you cannot protect your menus.