Hide workbook

  • Thread starter Thread starter Jesse
  • Start date Start date
Jesse said:
Is there a way to open a workbook in the background and have it not be
visible?
Click to expand...

Hi Jesse,

Here's the general idea of how to do this. Be sure to change the
workbook path and name to fit your circumstances.

Sub OpenWorkbookHidden()
Dim wkbBook As Workbook
Application.ScreenUpdating = False
Set wkbBook = Workbooks.Open("E:\Book1.xls")
wkbBook.Windows(1).Visible = False
Application.ScreenUpdating = True
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
This worked awesome, thanks Rob.

Jesse




Rob Bovey said:
Hi Jesse,

Here's the general idea of how to do this. Be sure to change the
workbook path and name to fit your circumstances.

Sub OpenWorkbookHidden()
Dim wkbBook As Workbook
Application.ScreenUpdating = False
Set wkbBook = Workbooks.Open("E:\Book1.xls")
wkbBook.Windows(1).Visible = False
Application.ScreenUpdating = True
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
Click to expand...
 
Back
Top