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? |
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? |
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 |
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 |
Thanks to both responses - they both work!
Andrew |
All times are GMT +1. The time now is 02:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com