View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DavidUp DavidUp is offline
external usenet poster
 
Posts: 2
Default Disable Workbooks_Open() Macro when opening from VBA

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