Saving Macro - need help
 

I had a macro sent to me to use in EXCEL.

It was saved to a specific worksheet, say "sheet 1".

I want to move or copy it to the PERSONAL.XLS so I can see it whenever I
open any EXCEL file.

I am confused on how to accomplish this.

I have tried to copy-and-paste it, but I can't figure out how to save it to
the PERSONAL.xls book.

I am new to Macros - any help would be appreciated.

Thanks,

Jon

Saving Macro - need help
 

The safest way to do this is to unhide your personal.xls
windowunhidepersonal.xls
then goto the vb editor (alt f11)paste your macro into a module
SAVE at the workbook level instead of the vb level and hide personal.xls


--
Don Guillett
SalesAid Software

"jmcclain" wrote in message
...
I had a macro sent to me to use in EXCEL.

It was saved to a specific worksheet, say "sheet 1".

I want to move or copy it to the PERSONAL.XLS so I can see it whenever I
open any EXCEL file.

I am confused on how to accomplish this.

I have tried to copy-and-paste it, but I can't figure out how to save it
to
the PERSONAL.xls book.

I am new to Macros - any help would be appreciated.

Thanks,

Jon