Accessibility to macros

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?
 
D

Die_Another_Day

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
 

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

Unwanted workbooks on startup 2
Macro shortcuts are running macros in different open workbook 3
run macro in another workbook - error 1004 7
Excel Protection 2
Personal.xlsb counts as a workbook, can I "super" hide it? 6
Run code from another workbook 7
How to force macros refer to ActiveWorkbook 2
Macros disabled, not by security settings? 5

Top