macro in nonactive workbook

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have two workbooks open. Both have macros; but the
macros in the one that is not active stops working untill
it is again active. Is it possible to make macros work
even though their wookbook is not active?
 
Hi Paul,

maybe it is because you refer to the "ActiveWorkbook".
Try to work with their names "Workbooks("Name.xls")" ...
 
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

quick way to prohibit all editing/changes to workbook (2010) 2
Macro shortcuts are running macros in different open workbook 3
Run macro from active workbook whose name keeps changing 20
Unwanted workbooks on startup 2
Finding what if IE or Excel is opening a workbook 1
Run code from another workbook 7
Macro - New Workbook 1
Run time error 9 (Subscript Out Of Range) 4

Back
Top