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

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.

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

Likely you need to learn about personal.xls. :)
http://www.vbaexpress.com/forum/arti...rticle&artid=8
************
Anne Troy
www.OfficeArticles.com

"GTNet_Boss" wrote in message
...
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.

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

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

"Anne Troy" wrote in message ...
Likely you need to learn about personal.xls. :)
http://www.vbaexpress.com/forum/arti...rticle&artid=8
************
Anne Troy
www.OfficeArticles.com

"GTNet_Boss" wrote in message
...
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.