Opening specific worksheet from hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>
 
I'll try it!
Thanks to both replies

Dave Peterson said:
I don't speak HTML, but maybe:

<a href="file://c:/yourfolder/book1.xls#'sheet 1'!A1">click me</a>
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink to a spcific worksheet 6
link to a specific worksheet of a workbook with many worksheets 1
Excel shortcut options 0
Hyperlink Help 4
When sharing, can I force an Excel document to open in a certain view? 0
Preventing hyperlinks and vlookups from breaking 5
How can I make a Hyperlink to a cell within another worksheet rela 5
Preventing broken hyperlinks and vlookups 2

Back
Top