where did my old 2000 Excel macros go when I upgraded to 2003?

D

dcampbe1

I've lost all my best macros. Can I retrieve them from the old Excel 2000
location?
 
K

Kevin B

Do a file search for Personal.xls, which is where your global macros might
be, your current version may not be pointing to the correct location.
 
G

Gord Dibben

Macros can live in the workbooks in which they were created or in
Personal.xls.

You also could have placed the macros in a workbook and saved it as an
Add-in(*.xla)

If in Personal.xls, you must find that file and store it in your XLSTART
folder.

If in workbooks, just open those workbooks to access the macros.

If in an add-in, find it and load it through Tools>Add-ins.


Gord Dibben Excel MVP




I've lost all my best macros. Can I retrieve them from the old Excel 2000
location?
Click to expand...

Gord Dibben MS Excel MVP
 
Top