Protected Toolbar Disappears When You Move It
Article ID: 136221
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 95 Standard Edition
This article was previously published under Q136221
SYMPTOMS
In Microsoft Excel, when you try to move a protected toolbar to the
docking area, the toolbar may disappear.
CAUSE
This situation occurs when you protect the toolbar by running a Visual
Basic procedure that contains the xlNoDockingChanges property.
WORKAROUND
To redisplay the toolbar, use the following steps:
- On the View menu, click Toolbars.
- Clear the check box next to the name of the toolbar that has
disappeared.
- Click OK.
- On the View menu, click Toolbars.
- Place a check in the check box beside the name of the toolbar that has
disappeared.
- Click OK.
MORE INFORMATION
The xlNoDockingChanges property is one of five different levels of
protection that you can place on a toolbar. These levels of protection
can be assigned to the toolbar by using a macro.
REFERENCES
For more information about toolbar protection, choose the Index tab in
Microsoft Excel Help Contents on the Help menu and type:
Additional query words: XL7
Keywords: kbprogramming KB136221