How to open a spreadsheet on a named sheet from a hyperlink?
 

Hi,
Can anyone help me with this? I have looked all through Excel help and the
only hyperlink info concerns inserting them into a cell.

I have a spread sheet that has numerous named sheets within it. Opening the
spreadsheet from a hyperlink on a webpage always opens it on sheet # 1.

Is there any way of opening the spreadsheet on a named tab, lets say for
example I have 3 sheets, Request, Cancel and Amend?
I want to have seperate hyperlinks on the webpage open the speadsheet with
the appropriate sheet active.
Really appreciate any help you can give me with this.

Many thanks

Paul

How to open a spreadsheet on a named sheet from a hyperlink?
 

Hi Paul,

Insert Hyperlink, select an Excel file, click the Bookmark button, select a
sheet from the Cell reference list.

Ed Ferrero
http://www.edferrero.com

Hi,
Can anyone help me with this? I have looked all through Excel help and
the
only hyperlink info concerns inserting them into a cell.

I have a spread sheet that has numerous named sheets within it. Opening
the
spreadsheet from a hyperlink on a webpage always opens it on sheet # 1.

Is there any way of opening the spreadsheet on a named tab, lets say for
example I have 3 sheets, Request, Cancel and Amend?
I want to have seperate hyperlinks on the webpage open the speadsheet with
the appropriate sheet active.
Really appreciate any help you can give me with this.

Many thanks

Paul