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

[GTNet_Boss]

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/arti...rticle&artid=8
************
Anne Troy
www.OfficeArticles.com

"GTNet_Boss" <[email protected]> wrote in message
news:[email protected]...
>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.

[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

"Anne Troy" <[email protected]> wrote in message news:[email protected]...
> Likely you need to learn about personal.xls.
> http://www.vbaexpress.com/forum/arti...rticle&artid=8
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "GTNet_Boss" <[email protected]> wrote in message
> news:[email protected]...
> >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.
>
>