Running a macro from another workbook

E

Ed Davis

I have a project where 5 workbooks are open. When I attempt to run a macro
from book2 the macro from book1 runs instead.
They do have the same name "Unprotect_Sheets" but the sheet names are not
the same.
How do I make sure this does not happen?
 
E

Ed Davis

I use shortcut keys to call this macro and both macros have the same
shortcut keys just separate workbooks.


--
Thank You in Advance
Ed Davis
Bob Phillips said:
Use Application.Run, it is explained in help.
Click to expand...
 

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

Closing workbooks programatically 5
copy values from 11 books to 1 sheet 7
Change workbook name to a generic name 4
comparing values from one workbook with another workbook 3
Calling excel macro not located in that workbook. 2
Validation rules 2
Save Macro enabled WB as w/o macro 13
Calling open workbook from another workbook 8

Top