Where are macros stored?

  • Thread starter Thread starter Denise
  • Start date Start date
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
 
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

Unhide macro worksheet 2
Vista problem with NO Personal Macro Workbook in Startup Folder 6
Personal.xls will not open when I open excel 2
Toolbar Error - can't find macros 7
Macro Will Not Save 2
Personal Macro Workbook 1
Change location of PERSONAL.XLS? 2
personal.xls 2

Back
Top