| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How: open a workbook with auto macro disabled using code?
I am trying to open a number of workbooks from VBA in excel and I need to
open them with macros disabled or auto macro disabled. This is because the worksheets I need to open have an auto macro which loads data from a server and I do not want it to run. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
open a workbook with auto macro disabled using code?
Application.EnableEvents = False
workbooks.Open "C:\MyFolder\Myfile.xls" Application.EnableEvents = True disables the startup macros. -- Regards, Tom Ogilvy "mike_cutting-edge" wrote in message ... I am trying to open a number of workbooks from VBA in excel and I need to open them with macros disabled or auto macro disabled. This is because the worksheets I need to open have an auto macro which loads data from a server and I do not want it to run. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to code VBA: Auto open workbook and run macro | Excel Discussion (Misc queries) | |||
| auto run macro on workbook open | Excel Programming | |||
| auto run macro on workbook open | Excel Programming | |||
| auto run macro at workbook open | Excel Programming | |||
| Insert VBA code with a macro in a .xls file by workbook open event | Excel Programming | |||
Linear Mode
