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

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

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



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

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..


--
Hope that helps.

Vergel Adriano


"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