Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can disable events before you open the second workbook to prevent the
workbook_open from firing: Dim wkbk1 as workbook dim wkbk2 as workbook set wkbk1 = workbooks.open(filename:=....) application.enableevents = false set wkbk2 = workbooks.open(filename:=....) application.enableevents = true Depending on what you're doing, you may want to turn off events before you do anything with that second workbook to keep all events from firing in that workbook. Steve wrote: Is it possible to open Workbook1 with macros allowed but then open Workbook2, from within Workbook1, but with macros disabled? I really only am trying to copy data from Workbook2 to Workbook1 and don't need the "Open workbook" macro to run in Workbook2. It just really slows down the copy process -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open Workbook Macro??? | Excel Discussion (Misc queries) | |||
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) | |||
how can I run a macro when I open a workbook? | Excel Discussion (Misc queries) |