Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 27th 05, 04:49 PM
AndrewMead
 
Posts: n/a
Default 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   Report Post  
Old July 27th 05, 04:59 PM
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Old July 27th 05, 09:23 PM
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Old July 27th 05, 10:44 PM
AndrewMead
 
Posts: n/a
Default

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   Report Post  
Old July 28th 05, 08:58 AM
AndrewMead
 
Posts: n/a
Default

Thanks to both responses - they both work!
Andrew




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
... How do I Hyperlink to worksheet of an Excel file ... Dr. Darrell Excel Discussion (Misc queries) 1 July 22nd 05 02:23 PM
print report with data from specific worksheet JG_HILL Excel Discussion (Misc queries) 1 May 14th 05 07:12 PM
Hyperlink to specific worksheet in Excel Glenn Mulno Links and Linking in Excel 2 February 7th 05 07:01 PM
How do I open to a specific worksheet every time? TNT New Users to Excel 2 February 6th 05 01:06 PM
How to control worksheet initialization upon opening a workbook Nick Excel Worksheet Functions 3 October 31st 04 05:36 PM


All times are GMT +1. The time now is 09:25 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017