Posted to microsoft.public.excel.programming

Joanne[_5_] Joanne[_5_] is offline

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Answers to questions posing more questions in a workbook	sbelle1	Excel Worksheet Functions	2	August 8th 09 01:02 AM
questions about at sum	nreily	Excel Discussion (Misc queries)	2	May 14th 09 04:27 PM
2 VB Questions	JRD-CFW[_2_]	Excel Worksheet Functions	2	October 7th 08 12:31 AM
View Questions and Answer to questions I created	Roibn Taylor	Excel Discussion (Misc queries)	4	July 24th 08 12:05 AM
VBA questions	Adam	Excel Programming	1	April 25th 05 11:45 AM

All times are GMT +1. The time now is 04:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us