All Workbook Macro
Excel creates and saves macros to the current workbook by default. However, you can create a macro that can be executed from any workbook or spreadsheet. The macro will have to be placed in a hidden file, but you can unhide and edit to your desire. To get started follow these steps:
- First, enter a macro in a blank workbook.
- Choose File/Save As and name the workbook personal.xls.
- Now, still in the Save As dialog box, navigate to C:\Program Files\Microsoft Office\Office\XLStart and click Save.
- Next, choose Window/Hide and then choose File/Exit. When asked if you want to save changes, click Yes.
Your macro will now be available to all workbooks. Since personal.xls is hidden, it won't appear unless you choose Window/Unhide, which is what you'll need to do to add or modify any macros.
Tip is from Sue Whitehouse of Tipworld, visit their website for more tips by clicking on the globe
Just click on the button for the Tiproom's Home Page.
Date of last revision: 26 September 2001.