CommandBar.Visible Property

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.Visible

expression A variable that represents a CommandBar object.

Return Value
Boolean

Remarks

The Visible property for newly created custom command bars is False by default.

The Enabled property for a command bar must be set to True before the Visible property is set to True.

Example

This example steps through the collection of command bars to find the Forms command bar. If the Forms command bar is found, the example makes it visible and protects its docking state.

foundFlag = False For Each cmdbar In CommandBars If cmdbar.Name = "Forms" Then cmdbar.Protection = msoBarNoChangeDock cmdbar.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