Location of macros??

[dave]

I had a document with macro's I recorded...my computer
profile/username was changed, and now I open the same
document and none of the macro's are there. Any idea
where the macros are stored??

Dave

 

[Jan Karel Pieterse]

Hi Dave,

I had a document with macro's I recorded...my computer
profile/username was changed, and now I open the same
document and none of the macro's are there. Any idea
where the macros are stored??

They are probably in a file called Personal.xls, located in your old
XLSTART directory beloning to your previous user setup.
Search all folders for that file. If you cannot find it (because of
lack of access rights), contact your IT dept and ask them to search
your HD for the file. They were the ones that made it go away in the
first place <G>

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[Ken Wright]

And hopefully the change didn't include them re-imaging your machine, else they
may be looking for a backup of your old image to get this