Save Macro



My Macro was saved in Personal Macro Workbook. How can I retrieve this

How to make the macro run in other spreadsheets without copying it each time

I'm using version 2003. Thanks.


the personal.xls is placed the the xlstart folder so that it will open when
excel opens. the xlstart folder varies by version but in 03 i think it is.....
c:/program files/microsof office/office 10/xlstart
if the personal.xls is open, then all macros in the personal.xls will be
available for any and all files.


Dave Peterson

If you open personal.xls and enable macros to run, you can use:
to select the macro to run.

Or you could hit F8 to get to that run dialog quickly.

But someday, when you have more macros, you'll want to create a nicer way of
running them.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:

Here's how I do it when I want a toolbar:
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site: -- For macros for all workbooks (saved as an

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question