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:


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 globe
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 26 September 2001.