I keep losing saved Excel macros, what am I doing wrong?

[Guest]

I have made several extensive macros in Excel to speed up my work but after a
couple of days they are no longer avaiable. How can I save these for more
than a day or two.

 

[Anne Troy]

Likely you need to learn about personal.xls.
http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=8
************
Anne Troy
www.OfficeArticles.com

 

[David McRitchie]

and if they are in your personal.xls you might make it a point
to save that file File, Save
from within the Visual Basic Editor
with the personal.xls project selected.
http://www.mvps.org/dmcritchie/excel/install.htm

And of course you would want to make sure all of your Excel
files including your personal.xls file are being backed up.
http://www.mvps.org/dmcritchie/excel/backup.htm

HTH,
David McRitchie, Microsoft MVP - Excel