View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joanne[_5_] Joanne[_5_] is offline
external usenet poster
 
Posts: 2
Default 2 auick questions please

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