Show All

Hide All

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, and then click the toolbar you want. If the button you want doesn't appear, click More Buttons.) 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

4. If your custom toolbar does not appear, point to Toolbars on the View menu, and then select your toolbar.
5. 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).
6. 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.
7. 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.

   How?

   1. Set the security level to Medium or Low.

      How?

      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.
   2. 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.
   3. On the Tools menu, point to Macro, and then click Visual Basic Editor.
   4. On the View menu, click Project Explorer .
   5. Drag the module you want to copy to the destination workbook.