Hide workbook

  • Thread starter Thread starter Jesse
  • Start date Start date
J

Jesse

Is there a way to open a workbook in the background and have it not be
visible?

Jesse
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addin not allowing thisworkbook.save in before save event 3
Why do charts disappear? 2
Excel Protection 2
Is there a command to 'Hide' the Activeworkbook? 1
how to reshow userform after following a link 1
Excel application main window background 3
Lost view of Application 2
Loop to hide sheet based on cell 1

Back
Top