Disable Workbooks_Open() Macro when opening from VBA
Sub OpenWorkBook()
Application.EnableEvents = False
Workbooks.Open Filename:= _
"F:\Files\Permanent File Information.xls"
Application.EnableEvents = True
End Sub
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"DavidUp" wrote in message
...
I am trying to open a Workbook "Permanent File Information.xls" from a
macro
in another workbook without invoking the workbooks_open macro in
"Permanent
File Information.xls"
This is the equivalent of holding down the <shift key whilst opening the
workbook.
I have tried recording two macros to see what the difference is but
although
they give different macros they both allow the workbooks_open macro to run
when the two macros are run.
Sub OpenWorkBook()
Workbooks.Open Filename:= _
"F:\Files\Permanent File Information.xls"
End Sub
Sub ShiftOpenWorkbook()
Workbooks.Open Filename:= _
"F:\PA Files\Permanent File Information.xls", Editable:=True
End Sub
Has anyone got any ideas how to stop the workbooks_open macro running from
VBA?
Thank you
|