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
[Quoted Text] > 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
|