Saving Macro - need help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
The safest way to do this is to unhide your personal.xls>
window>unhide>personal.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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro for all Excel Workbooks to print to PDF 2
Saving information to PERSONAL.XLS 1
Porting from Excel 2003 to Excel 2010 12
Icons/Macros Missing 3
Using XLM Macro Sheet in Excel 2010 1
Accessing the PERSONAL.XLS without a macro ever recorded by user. 3
toolbar macro buttons 1
Digitally Signed Macros in Personal.XLS 3

Back
Top