Saving Macro into personal macros space

  • Thread starter Thread starter J Brogdon
  • Start date Start date
J

J Brogdon

I've got a spread sheet that has a macro in it. I would
like to save the macro into my personal space so I can run
it on other spread sheets. I can't find documention for
this. Any help would be appreciated.

Thanks
 
The Personal.xls workbook is created when you record your first macro to be
saved in it, as I understand it. What I had to do for a co-worker was go to
Tools>Macro>Record New Macro, and just let it save whatever it came up with
into Personal.xls. Then I had to go to Window>Unhide and choose to Unhide
Personal. When it opened Personal, I hit ALT+F11, opened the new macro I
had just recorded (with nothing in it), and pasted in the code I wanted to
keep.

Ed
 
JBrogdon,

There should be Personal.xls file where your personal macros are stored.
If you can't find it in the VBA editor, it hasn't been created yet.
To create it, start the macro recorder.
Click the drop down for where to store it and choose "Personal Macro
Workbook"
Place an x in any ceel, delete it and then stop the recorder.
Now you'll have a Personal.xls file in the VBA editor.
Cut or Copy/Paste the macro from your workbook into the
Personal.xls workbook.

John
 
Back
Top