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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top