Accessibility to macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to know if it is possible to make a macro that I recorded in one
workbook, accessible from another one? Right now it seems that I have to have
the workbook with the marco that I want to run, open. Can I make that macro
available in all workbooks?
 
Yes the workbook does need to be opened. However it does not need to be
active and it can also be an addin which runs behind the scenes. Do a
google search on creating custom XL addins to find info on creating a
custom XL addin

Die_Another_Day
 
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

Excel is removing Macros from workbook 3
Unwanted workbooks on startup 2
Macro shortcuts are running macros in different open workbook 3
How to call Excel add-in macro from a button… 1
Problem in adding macro to ribbon through Add-in 7
VBA Debug Issue 2
Excel Protection 2
run macro in another workbook - error 1004 7

Back
Top