View Single Post
  #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