Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Opening specific worksheet from hyperlink
I can open a workbook from a hyperlink on a webpage, but I want to have
several links which will open specific worksheets within the workbook. Can I do this and if so, how do I specify the sheet? |
#2
|
|||
|
|||
Insert named ranges, and then add #NamedRange to the end of the hyperlink.
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com "AndrewMead" wrote in message ... I can open a workbook from a hyperlink on a webpage, but I want to have several links which will open specific worksheets within the workbook. Can I do this and if so, how do I specify the sheet? |
#3
|
|||
|
|||
I don't speak HTML, but maybe:
<a href="file://c:/yourfolder/book1.xls#'sheet 1'!A1"click me</a AndrewMead wrote: I can open a workbook from a hyperlink on a webpage, but I want to have several links which will open specific worksheets within the workbook. Can I do this and if so, how do I specify the sheet? -- Dave Peterson |
#4
|
|||
|
|||
I'll try it!
Thanks to both replies "Dave Peterson" wrote: I don't speak HTML, but maybe: <a href="file://c:/yourfolder/book1.xls#'sheet 1'!A1"click me</a AndrewMead wrote: I can open a workbook from a hyperlink on a webpage, but I want to have several links which will open specific worksheets within the workbook. Can I do this and if so, how do I specify the sheet? -- Dave Peterson |
#5
|
|||
|
|||
Thanks to both responses - they both work!
Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
... How do I Hyperlink to worksheet of an Excel file ... | Excel Discussion (Misc queries) | |||
print report with data from specific worksheet | Excel Discussion (Misc queries) | |||
Hyperlink to specific worksheet in Excel | Links and Linking in Excel | |||
How do I open to a specific worksheet every time? | New Users to Excel | |||
How to control worksheet initialization upon opening a workbook | Excel Worksheet Functions |