How do I make a macro available to all workbooks

  • Thread starter Thread starter ebsjunior
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

saving macro from workbook to Personal Macro Workbook 1
Macro available in all workbooks 8
How do I make a VBA procedure available to all workbooks? 2
Disable Macro Alert 2
Macros Available without hiding 'personal.xls'? 3
Having a macro/function available in new spreadsheets 1
Macro to push data to another workbook 0
Macro to open seperate workbook 3

Back
Top