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.)
 
Back
Top