LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.links
Paul
 
Posts: n/a
Default How to open a spreadsheet on a named sheet from a hyperlink?

Hi,
Can anyone help me with this? I have looked all through Excel help and the
only hyperlink info concerns inserting them into a cell.

I have a spread sheet that has numerous named sheets within it. Opening the
spreadsheet from a hyperlink on a webpage always opens it on sheet # 1.

Is there any way of opening the spreadsheet on a named tab, lets say for
example I have 3 sheets, Request, Cancel and Amend?
I want to have seperate hyperlinks on the webpage open the speadsheet with
the appropriate sheet active.
Really appreciate any help you can give me with this.

Many thanks

Paul
 
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
Using a relative SHEET reference for source data in a chart James Charts and Charting in Excel 6 August 16th 05 05:07 PM
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file DCheslock Excel Discussion (Misc queries) 1 May 5th 05 10:46 PM
file open via IE hyperlink causes already open files to shrink and tile Marc Setting up and Configuration of Excel 0 May 4th 05 08:13 PM
can't move a named cell without breaking a hyperlink to that cell Snakeye Links and Linking in Excel 3 January 26th 05 11:57 PM
Hyperlink to specific sheet in Excel Web File jd17 Links and Linking in Excel 0 December 8th 04 09:03 PM


All times are GMT +1. The time now is 04:32 AM.

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

About Us

"It's about Microsoft Excel"