Search all of Office.com
 
Support / Excel / Excel 2003 Help and How-to / Startup and Settings / Installing and Customizing / Toolbars and Commands
 
 

Use custom toolbars from earlier Excel versions

Applies to: Microsoft Office Excel 2003

 

If you have multiple Microsoft Excel versions on your system, or have toolbars (toolbar: A bar with buttons and options that you can use to carry out commands. To display a toolbar, point to Toolbars on the View menu. If you don't see the button you want, click the arrows at the right end of the toolbar.) you want to use on other systems or share with other users, you can merge those custom toolbars into the current version of Excel.

  1. On the File menu, click Open.
  2. In the Files of type box, click Toolbars.
  3. Open the toolbar file for the version you want.

Your toolbar settings are stored in the following files and locations:

Excel Version File Name Location
Excel 2002 Excel.xlb C:\Documents and Settings\username\Application Data\Microsoft\Excel
Excel 2000 Excel.xlb C:\Documents and Settings\username\Application Data\Microsoft\Excel
Excel 97 username8.xlb Windows folder, unless your administrator specifies a different location
Excel 95 If user profiles are turned on, username.xlb; if user profiles are not turned on, Excel5.xlb Windows folder
Excel 5 Excel5.xlb Windows folder
Excel 4 Excel.xlb Windows folder
  1. If your custom toolbar does not appear, point to Toolbars on the View menu, and then select your toolbar.
  2. If you opened an Excel toolbar file from another system, and you want to save the merged toolbars in the current Excel toolbar file, click Customize on the Tools menu and make at least one change to a merged toolbar (add or remove a button, for example).
  3. To save the merged toolbars in the current Excel toolbar file, click Exit on the File menu. The next time you run Excel, the merged toolbars will be displayed. If your custom toolbars contain buttons from earlier Excel versions that aren't included in the current version of Excel, these buttons appear as gray boxes. If you click one of these buttons, the Assign Macro dialog box appears.
  4. If your custom toolbars contain buttons that run macros, you'll also need to copy the macros to any workbooks where you want to use the buttons.

ShowHow?

  1. Set the security level to Medium or Low.

ShowHow?

  1. On the Tools menu, click Options.
  2. Click the Security tab.
  3. Under Macro Security, click Macro Security.
  4. Click the Security Level tab, and then select the security level you want to use.
  1. Open the workbook that contains the module (module: A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.) you want to copy and the workbook you want to copy the module to.
  2. On the Tools menu, point to Macro, and then click Visual Basic Editor.
  3. On the View menu, click Project Explorer Project Explorer button.
  4. Drag the module you want to copy to the destination workbook.
 
 

See Also