Microsoft KB Archive/136221

= 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:


 * 1) On the View menu, click Toolbars.
 * 2) Clear the check box next to the name of the toolbar that has disappeared.
 * 3) Click OK.
 * 4) On the View menu, click Toolbars.
 * 5) Place a check in the check box beside the name of the toolbar that has disappeared.
 * 6) 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.

