Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run macro on only one open workbook
I have several workbooks, each with a macro (to rearrange data) that runs "on
open". When I open a second workbook (wk2), the macro runs, then encounters an error when it tries to run (re-run) the macro on the first workbook (wk1). My goal is have the macro fire only on the workbook that I'm opening, and then stop. I'm curious as to why the macro on wk1 tries to run when the open event has not occurred. Do I need some type of command to stop the macro in wk2? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run a macro when I open a workbook | Excel Discussion (Misc queries) | |||
How to Run Macro in open workbook/s | Excel Discussion (Misc queries) | |||
run macro on workbook open | Excel Discussion (Misc queries) | |||
Macro to open another workbook | Excel Programming | |||
How to run VBA macro when the workbook is open? | Excel Programming |