Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
PatrickW
 
Posts: n/a
Default Hyperlinks opening an Excel file at a particular tab

Dear All,

One of my colleagues wants to create multiple links on a website to ONE
Excel spreadsheet and get it to open the appropriate tab, ie click on the
first link and it opens myfile.xls at tab 1, click on another link and it
opens the same file but on another tab, etc.

Any ideas??


TIA


Patrick
  #2   Report Post  
Mystic User
 
Posts: n/a
Default

If you are using Insert-Hyperlink to create the hyperlink then you can add
the following to the address. myfile.xls#tab_1
This should allow you to link to each separate tab.
Good luck
pootonline
--
You can never know it all


"PatrickW" wrote:

Dear All,

One of my colleagues wants to create multiple links on a website to ONE
Excel spreadsheet and get it to open the appropriate tab, ie click on the
first link and it opens myfile.xls at tab 1, click on another link and it
opens the same file but on another tab, etc.

Any ideas??


TIA


Patrick

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 1 February 19th 05 08:51 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:01 PM
Saving a Excel 97 file into Excel 2003 file Wil Excel Discussion (Misc queries) 1 December 13th 04 11:51 PM


All times are GMT +1. The time now is 01:39 PM.

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

About Us

"It's about Microsoft Excel"