XL98: How to Use a Toolbar Button to Open a File Indirectly

MORE INFORMATION

1. In Microsoft Excel, create a new workbook.
2. Press OPTION+F11 to activate the Visual Basic Editor. (Or, click the Tools menu, point to Macro, and then click Visual Basic Editor.)
3. Click Module on the Insert menu. In the Code window, type the following code:

          Sub Test()
          End Sub
   						

4. Click Close and Return to Microsoft Excel on the File menu to return to the workbook.
5. On the View menu, point to Toolbars and click Customize.
6. Click the Command tab in the Toolbars dialog box. Select Macros in the Categories list box.
7. Drag the Custom Button over a toolbar and release the mouse button.
8. Click Modify Selection in the Customize dialog box, and then click Assign Macro on the menu that appears. Click Test Macro name listbox, and then click OK.
   
   This will assign the macro Test to the custom button.
9. In the Customize dialog box, click Close.
10. On the File menu, click Save.
11. On the File menu, Click Close.