Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook withAuto-open Macros without transferring control
I have an Excel workbook (A) in excel XP that contains VBA code to open
workbook B. Application.AutomationSecurity = msoAutomationSecurityForceDisable Application.EnableEvents = False Set LHSwb = Workbooks.Open(LHS_PATH & "/" & LHS_files.Value) Application.AutomationSecurity = msoAutomationSecurityLow Now B has some Auto_open macros in it and what happens after the the above lines execute is that control seems to transfer to the VBA code in B alhtough nothing really runs My code in A is then reset and goes back to the start of the sub without executing any statements after Set LHSwb = Workbooks.Open(LHS_PATH & "/" & LHS_files.Value) Any help would be appreciated. Thanks, Sukhin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel, Book1 opens, remains open with other workbook open | Excel Discussion (Misc queries) | |||
Disable Macros when opening workbook | Excel Programming | |||
How to control worksheet initialization upon opening a workbook | Excel Worksheet Functions | |||
Open workbook-macros enabled, opening another with macros | Excel Programming | |||
Opening a workbook containing macros from VB | Excel Programming |