Default opening to certain sheet of workbook

  • Thread starter Thread starter Johnny
  • Start date Start date
J

Johnny

I have a workbook with numerous sheets that I save to HTML
and post it on a website. The workbook (hyperlink) opens
to the last sheet viewed during the last save. Since it
somehow "knows" to open the last saved sheet is there a
way to force open certain sheets through a link? I would
like link A to open sheet A, link B to open sheet B and
son on.
Thanks in advance!
 
One way:

Add an anchor to to your hyperlink. In the Hyperlink dialog, after the
filename, add to the end of the URI:

#SheetA!A1 or #SheetB!J10
 
I can't get it to work.
-----Original Message-----
One way:

Add an anchor to to your hyperlink. In the Hyperlink dialog, after the
filename, add to the end of the URI:

#SheetA!A1 or #SheetB!J10




.
Click to expand...
 
Back
Top