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

[Inas]

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]

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 Autpen()
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