Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving macro from workbook to Personal Macro Workbook | Excel Discussion (Misc queries) | |||
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
Deleting nonactive Sheets in Excell | Excel Programming | |||
Deleting nonactive Sheets in Excell | Excel Programming | |||
Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please | Excel Programming |