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

2.
i don't know.
:)
susan


On Aug 20, 3:54 pm, "Joanne" wrote:
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