View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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