ExcelBanter - macro in nonactive workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - macro in nonactive workbook (https://www.excelbanter.com/excel-programming/319886-macro-nonactive-workbook.html)

Paul

macro in nonactive workbook

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?

Monika Weber

macro in nonactive workbook

Hi Paul,

maybe it is because you refer to the "ActiveWorkbook".
Try to work with their names "Workbooks("Name.xls")" ...

--
Greetings,
Monika Weber [Microsoft MVP für Excel]
http://www.jumper.ch (Office Help Desk)

All times are GMT +1. The time now is 11:58 PM.