XL2000: Resetting Toolbox to Default Controls and Layout (213771)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q213771

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, follow these steps:
  1. Quit Microsoft Excel.
  2. Click Start, point to Find, and then click Files or Folders.
  3. On the Name & Location tab, in the Named box, type Excel.box.
  4. In the Look in list box, select the drive on which you installed Microsoft Excel, and then click Find Now.

    NOTE: By default, the Excel.box file is located in the Windows\Msapps\Msforms folder.
  5. 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 the Toolbox, follow these steps:
  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, follow these steps:
  1. Right-click any tab in the Toolbox, and then 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, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type toolbox in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbprb kbProgramming KB213771
©2004 Microsoft Corporation. All rights reserved.