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.

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.