Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Macro | 28 comments | Create New Account
Click here to return to the 'Macro' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Macro
Authored by: deggy on Sep 03, '04 04:53:56AM

I have been able to run the macro on the sheet I have open, but how do I get the macro to live in all new documents I create?



[ Reply to This | # ]
Macro
Authored by: sinjin on Sep 03, '04 02:12:54PM

From Excel Help:
If you want a macro to be available whenever you use Excel, store the macro in the Personal Macro Workbook in the Microsoft Office X->Office->Startup->Excel folder.

Note that this file is usually open, but hidden, every time you start Excel. It should be listed in the drop down menu for places to save a macro, and you should be able to "unhide" it from the Window menu.



[ Reply to This | # ]