Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to disable always ask before opening this type of file | Excel Discussion (Misc queries) | |||
Code to select 'Disable Macro' when opening an EXTERNAL FILE | Excel Programming | |||
Break/disable a macro when opening a workbook | Excel Programming | |||
Disable the opening of another workbook | Excel Programming |