How do I make a macro available to all workbooks

E

ebsjunior

How do I make a macro (VBA procedure that also uses a User Form
available to any existing or new workbook that I open or create
without having to open the workbook where the macro was originall
programmed
 
B

Bob Umlas

Put the macro in your personal.xls, which is stored in the xlstart
directory. Hide the personal.xls, then save changes when asked to as you
exit. It will always open and the macros will be available to each session
of Excel.
The workbook containing the macro must be open for the macros to run.
 
Top