Hi I have two issues that I need Help with. please See Below.

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.

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.

I use the book mark method to add the hyper link to specific sheet, is there an add on i can enter into the hyper link formulae or does it have be done using a macro. or is there away round this.