My SpreadSheet Magic

Adding your own toolbars

Applies to
Microsoft Excel 2000

If you don't want to modify the existing toolbars, you can add a new toolbar and then customize it with the buttons and commands you use most frequently.

Creating a new toolbar

To create your own toolbar:

1. Click the Toolbars tab on the Customize dialog box.
2. Click the New button, and then type a name for the toolbar.
3. Click the Commands tab, and drag buttons and commands to the toolbar.

   Note Adding commands to your own toolbar doesn't remove them from the existing toolbar where they normally appear.

Once created, you can display and hide your custom toolbar as you do any toolbar: right-click any toolbar or the menu bar, and then select or clear the check box for your custom toolbar.

Excel 2000 saves your custom toolbar, and any other toolbar and menu changes you've made, when you exit from Excel. Excel saves toolbar settings in file Excel.xlb, located in your user profile folder. For the location of this folder, type user profile folder in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

Tip You can create and open different versions of this file to create more than one toolbar configuration or share a custom toolbar with other users. For more information, see How to use custom toolbars from previous versions of Excel.

Creating buttons for your macros and hyperlinks

If you use macros to automate tasks that you perform frequently, you can create your own toolbar buttons to run the macros. You can also create buttons that provide hyperlinks to files and Web pages that you use frequently.

Recording macros

For information about recording macros, type record a macro in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search. If you want your macro button to be available whenever you use Excel, make sure you store it in the location recommended in the procedure.

Add a new button, or create your own

1. On the Tools menu, click Customize.
2. Click the Commands tab, click Macros, and drag the Custom Button item to the toolbar where you want a macro or hyperlink button.

More info: http://office.microsoft.com/en-us/assistance/HA010548161033.aspx

posted by Noel J @ 2:53 PM