Installing a macro

  • Thread starter Thread starter bt707
  • Start date Start date
B

bt707

I have a macro that I created, how do I install it where it will always
be available when I open exce. Right now I can only use it in the file
that I created it in.

Thanks,!!!
 
bt,

Put it in Personal.xls, instead of the individual workbook. When you record
a macro, you have that option initially with the "Store Macro in" box. Or
later, you can copy it from the module in your workbook to a module in
personal.xls in the VBE. If you've never recorded a macro specifying
personal, then it won't exist. Record one (anything), and it'll be created.
Then it will appear in the VBE.
 
Back
Top