PDA

View Full Version : Open Workbook Options



MWE
11-08-2006, 07:00 PM
I am sure there is a simple way to do this, ...

I wish to Open a workbook but do not want it to be visible and do not want Workbook_Open in the target workbook to execute.

Thanks

johnske
11-08-2006, 07:41 PM
Hi Mark,

Something like this (untested)
Option Explicit

Sub OpenAndHideExample()

With Application
.EnableEvents = False
.ScreenUpdating = False

Workbooks.Open "Book1.xls"
Windows("Book1.xls").Visible = False

.EnableEvents = True
.ScreenUpdating = True
End With
End Sub