ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening specific worksheet from hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/37315-opening-specific-worksheet-hyperlink.html)

AndrewMead July 27th 05 04:49 PM

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?

Anne Troy July 27th 05 04:59 PM

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?




Dave Peterson July 27th 05 09:23 PM

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

AndrewMead July 27th 05 10:44 PM

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


AndrewMead July 28th 05 08:58 AM

Thanks to both responses - they both work!
Andrew




All times are GMT +1. The time now is 12:48 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com