CommandBar.Protection Property

Gets or sets a MsoBarProtection constant representing the way a command bar is protected from user customization. Read/write.

Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Syntax

expression.Protection

expression A variable that represents a CommandBar object.

Remarks

Using the constant msoBarNoCustomize prevents users from accessing the Add or Remove Buttons menu (this menu enables users to customize a toolbar).

Example
This example steps through the collection of command bars to find the command bar named "Forms." If this command bar is found, it's docking state is protected and it's made visible.

foundFlag = False For i = 1 To CommandBars.Count If CommandBars(i).Name = "Forms" Then CommandBars(i).Protection = msoBarNoChangeDock CommandBars(i).Visible = True foundFlag = True End If Next If Not foundFlag Then MsgBox "'Forms' command bar is not in the collection." End If

See also:

• CommandBar Object
• CommandBar Object Members