open and hide

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have register.xls that i open, on auto_open i want it to open data.xls and
make data.xls hidden

thanks in advance
 
Workbooks.Open Filename:="Data.xls"
ActiveWindow.Visible = False

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Choice

This will work...change the obvious bits to the location of the file

Sub Auto_Open()
Dim wbHidden As Workbook
Application.ScreenUpdating = False
Set wbHidden = Workbooks.Open("C:\Data.xls")
wbHidden.Windows(1).Visible = False
Application.ScreenUpdating = True
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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

open another workbook 2
networking 1
different workbooks 12
Open Workbook 3
Help with building a formula based on cell values 3
Workbook_Open command fails and blows up all cell formulas 2
Macros across multiple files 1
File open and close, get some data 2

Back
Top