Hyper Link

JOONA

New member
Joined
Dec 9, 2013
Messages
27
Reaction score
0
Points
0
1. I have two work books the 1st work book as a hyer link that is liked to a specfic sheet in another work book but after 24 hours when i come back to use the sheet, its says hyper link not valid. yet it works when i re- do the hyper link, I do not wish to do this everytime. is there away of getting the hyperlink to open the work book to the specific page without opening the work book 1st

2. I have another work sheet that will act as a main page within a work book, within this work book I will have 22 seprate work sheets. The main page will be called home where by you click on a hyper link that opens up one of the sheets, however my problem is this. i wish to hide all the sheets except the home page sheet and have the hyper links still work. I have already tried to do this but when i have hidden the sheets the hyper link does not work.
 

JOONA

New member
Joined
Dec 9, 2013
Messages
27
Reaction score
0
Points
0
Hi Here is the sperad sheet if anyone needs it
 

Attachments

  • Test.xlsx
    18.4 KB · Views: 5
Top