2 auick questions please

[Joanne]

1. activewindow.selectedsheets.visible = false
I know this will hide an active worksheet.
What I would like to know is how to hide the worksheet upon opening the
workbook.

2. Workbooks.Open spath & fname
opens my workbook
What I need to know is the syntax for how to update the links in fname.
fname.links.update??

Thanks for your help, as always I don't know where I'd be without yas.
Joanne

 

[Susan]

1.
public sub auto_open()
activewindow.selectedsheets.visible=false
end sub

2.
i don't know.

susan

 

[Susan]

actually, you'd have to select the proper sheet, or just refer to it
by name.

public sub auto_open()
dim ws as worksheet
set ws = activeworkbook.worksheets(1)
ws.visible=false
end sub

 

[Guest]

Joanne,

#2. To update the links when you open the file fname:

Workbooks.Open Filename:=fname, UpdateLinks:=1

Lookup the Open method in the VBA Help to see possible values for the
UpdateLinks parameter..