How do I make a VBA procedure 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
programme
 
You can't. If it isn't open, you can't use its macros.

You could store it in Personal.xls which gets stored in XLStart, and opens
when Excel starts.
 
You can't. The normal way to handle this is to put the code in a workbook
that's stored in your XLSTART directory, so it automatically loads when you
open Excel.
 
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

How do I make a macro available to all workbooks 1
VBA just stops when opening a macro workbook 10
Why do charts disappear? 2
How to apply a macro to all workbooks 2
Unwanted workbooks on startup 2
Excel 2002, VBA, macros and Windows 7 1
Calling a procedure from another workbook 4
Loop through all open workbooks except Personal.xls 5

Back
Top