Thread: Hide workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob Bovey Rob Bovey is offline
external usenet poster
 
Posts: 811
Default Hide workbook

"Jesse" wrote in message
news:GvcAb.19157$bC.16307@clgrps13...
Is there a way to open a workbook in the background and have it not be
visible?


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 *