Home 
Excel Macros Use Macros In More Than One Workbook
Search MS Office A-Z | Search Web Pages/ Design A-Z
Use Macros In More Than One Workbook
When you write an Excel macro, the macro is attached to your current workbook and is not available to other workbooks. However, you can create global macros in Excel. All you have to do is put them into a special workbook named Personal.xls.
To do this:
- Open a blank worksheet. Choose File | Save As and name the worksheet Personal.xls.
- Go to the folder 'c:\Program Files\Microsoft Office\Office\XLStart' and click Save to save the file and close the Save As dialog.
- Run Excel. It will open with Personal.xls. Choose Window | Hide and then choose File | Save and exit Excel.
- Each time you open Excel, Personal.xls will open hidden.
- To enter a macro into Personal.xls, you must choose Window | Unhide to make the sheet available.
Home Excel Macros Use Macros In More Than One Workbook
Search MS Office A-Z | Search Web Pages/ Design A-Z