HOW TO: Use Custom Toolbars from Excel 5.0 in Excel 2000 (211963)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q211963
For a Microsoft Excel 97 version of this article, see 161322.

IN THIS TASK

SUMMARY

This step-by-step article shows you how to use custom toolbars from Microsoft Excel 5.0 in Microsoft Excel 2000. When you upgrade Excel 5.0 to Excel 2000, built-in toolbars that you customize in Excel 5.0 and custom toolbars you create in Excel 5.0 do not appear in Excel 2000. Excel 2000 does not convert Excel 5.0 toolbars that are stored in the Excel5.xlb file.

back to the top

Use Custom Toolbars from Excel 5.0

To use toolbars that are stored in the Excel5.xlb file, follow these steps:
  1. Start Excel 2000.
  2. On the File menu, click Open.
  3. Locate the Excel5.xlb file, and then select it.
  4. Click Open.

    Excel does not open a workbook, but it does load the toolbars into random access memory (RAM).
  5. On the View menu, point to Toolbars, and then click the name of any toolbar that you created in Excel 5.0.
NOTE: If the Excel5.xlb file contains one of the built-in toolbars, the toolbar name that appears on the Toolbars menu is followed by an asterisk. For example, the standard toolbar appears as "Standard*".

back to the top

REFERENCES

For more information about toolbar files, click Microsoft Excel Help on the Help menu, type save more than one toolbar configuration in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

back to the top
Modification Type:MinorLast Reviewed:10/28/2004
Keywords:kbHOWTOmaster kbsetup KB211963
©2004 Microsoft Corporation. All rights reserved.