how can I open an excel file everytime on certain sheet?
 

I'm trying to create a new Work Book and it will be distributed for other
users; so, I want them to open the file on a certain sheet (Table of Contents
with a Hyperlink) even if they saved it on another...

Appreciate your kind Advice;

Thanks / Inas Moneim

how can I open an excel file everytime on certain sheet?
 

Excel will open the workbook with the worksheet that was visible the last time
you saved it.

If that's not sufficient, you could use a macro:

Option Explicit
sub Auto_Open()
application.goto worksheets("sheet9999").range("a1"), scroll:=true
end sub

Change the name of the sheet to what you want.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Inas wrote:

I'm trying to create a new Work Book and it will be distributed for other
users; so, I want them to open the file on a certain sheet (Table of Contents
with a Hyperlink) even if they saved it on another...

Appreciate your kind Advice;

Thanks / Inas Moneim

--

Dave Peterson