2 auick questions please

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joanne - 20 Aug 2007 20:54 GMT

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

Reply to this Message

Susan - 20 Aug 2007 21:02 GMT

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

2.
i don't know.

susan

> 1. activewindow.selectedsheets.visible = false
> I know this will hide an active worksheet.
[quoted text clipped - 8 lines]
> Thanks for your help, as always I don't know where I'd be without yas.
> Joanne

Reply to this Message

Susan - 20 Aug 2007 21:05 GMT

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

Reply to this Message

Vergel Adriano - 20 Aug 2007 23:34 GMT

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

Signature

Hope that helps.

Vergel Adriano

Reply to this Message