Thread
:
Saving Macro - need help
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett