Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
can't move a named cell without breaking a hyperlink to that cell | Links and Linking in Excel | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |