Where are macros stored?

D

Denise

Specifically, where are Macros stored? Is it in my C
drive?I've created some Macros, chosen them to be stored
in Personal macro workbook instead of the other choices,
and they are now arbitrarily stored in Personal.xls.
Is
 
D

Dave Peterson

Macros are stored in workbooks.

The next question is "where are workbooks stored?"

If you record a macro, you're given the option of what workbook to record into.
If you choose personal.xls, they'll go there.

If you choose, thisworkbook or new workbook, they'll go there.

(I always record a macro into a test workbook. Then I can tweak it as much as I
want with no concern for damaging my personal.xl* file.)
 

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

Similar Threads

Personal.xls will not open when I open excel 2
Toolbar Error - can't find macros 7
Change location of PERSONAL.XLS? 2
Macro Will Not Save 2
Where are Macros stored? 3
Relative Macro Assignments in Custom Menus 1
Macro linking to wrong workbook 2
personal.xls locked for editing 4

Top