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" <robj...@comcat.net> 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" <robj...@comcat.net> 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
>
>
>