XL97: Resetting Toolbox to Default Controls and Layout

Last reviewed: February 27, 1998
Article ID: Q159715
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

After you customize the Toolbox in the Visual Basic Editor, you cannot reset the Toolbox to the default configuration.

CAUSE

After you customize the Toolbox, there is no built-in method for resetting the Toolbox.

RESOLUTION

If you customize the Toolbox by adding Pages or ActiveX controls, or by deleting the standard controls, and you want to reset the Toolbox to its original configuration, do the following:

  1. Quit Microsoft Excel.

  2. On the Windows Start menu, point to Find, and then click Files Or Folders.

  3. Click the "Name & Location" tab and type "Excel.box" (without the quotation marks) in the "Named:" box.

  4. In the "Look in:" list, select the drive in which you installed Microsoft Excel.

  5. Click Find Now.

    NOTE: By default, the Excel.box file is located in the Windows\Msapps\Msforms folder.

  6. In the search results window at the bottom of the Find dialog box, click Excel.box, and then rename the file (for example, to Excel.bbb).

When you restart Microsoft Excel and the Visual Basic Editor, the Toolbox contains only the Controls page and all the default controls on the page.

MORE INFORMATION

By default, the Controls page of the Toolbox in the Visual Basic Editor contains the following controls:

   Selected Objects
   Label
   TextBox
   ComboBox
   ListBox
   CheckBox
   OptionButton
   ToggleButton
   Frame
   CommandButton
   TabStrip
   MultiPage
   ScrollBar
   SpinButton
   Image
   RefEdit

You can also export a page from the Toolbox as a .pag file. If you export a page from the Toolbox, you can import it back into the Toolbox after you reset the Toolbox to the default configuration.

Exporting Toolbox Pages

To export a page from your Toolbox, do the following:

  1. Right-click the tab for the page you want to export.

  2. On the shortcut menu, click Export Page.

  3. In the Export Page dialog box, select a destination folder, and then type a file name in the "File name:" box.

  4. Click Save.

This method saves the file with a .pag extension in the specified folder.

Importing Saved Toolbox Pages

To import a page into the Toolbox, do the following:

  1. Right-click any tab in the Toolbox and click Import Page on the shortcut menu.

  2. In the Import Page dialog box, locate and select the .pag file you want to import.

  3. Click Open.

This page is added to your Toolbox.

REFERENCES

For more information about the Toolbox, click the Index tab in Visual Basic for Applications Help, type the following text

   toolbox

and then double-click the selected text to go to the "Toolbox" topic.


Additional query words: XL97
Keywords : kbprg kbtool xlvbainfo xlui
Version : WINDOWS:97
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 27, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.