| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable macros in Workbooks.open
In a macro in Workbook_A, I call workbooks.open("Workbook_B"). Although I am
(obviously) running macros in Workbook_A, I don't want to run Workbook_B's startup macros when it is opened (but they are). How can I disable macros in the load of Workbook_B? Thanks, Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable macros in Workbooks.open
application.EnableEvents = False
workbooks.Open "Workbook_b.xls" application.EnableEvents = True -- Regards, Tom Ogilvy "mps" wrote: In a macro in Workbook_A, I call workbooks.open("Workbook_B"). Although I am (obviously) running macros in Workbook_A, I don't want to run Workbook_B's startup macros when it is opened (but they are). How can I disable macros in the load of Workbook_B? Thanks, Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Disable macros in Workbooks.open
Tom,
Perfect, thanks! Mike "Tom Ogilvy" wrote: application.EnableEvents = False workbooks.Open "Workbook_b.xls" application.EnableEvents = True -- Regards, Tom Ogilvy "mps" wrote: In a macro in Workbook_A, I call workbooks.open("Workbook_B"). Although I am (obviously) running macros in Workbook_A, I don't want to run Workbook_B's startup macros when it is opened (but they are). How can I disable macros in the load of Workbook_B? Thanks, Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cause workbook to fail to open if user opts to disable macros | Excel Programming | |||
| How can I disable macros after the initial open? | Excel Discussion (Misc queries) | |||
| Open Worbook and Disable Macros | Excel Discussion (Misc queries) | |||
| Open Worbook and Disable Macros | Excel Programming | |||
| Disable Button when no workbooks are open. | Excel Programming | |||
Linear Mode
