Advise

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
Here is the spreadsheet.
 

Attachments

  • Test.xlsx
    18.4 KB · Views: 8

Charles

Member
Joined
Feb 17, 2013
Messages
34
Reaction score
0
Points
6
Location
Biloxi
Excel Version(s)
Mac Excel 2011
Hi,

I do not have all of the answers. But this bit of code may help show the "Hidden" sheet/
Code:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Worksheets(Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)).Visible = xlSheetVisible
End Sub

Copy it to your worksheet code module.
Right click sheet tab "Home" select "View code" and then paste.
 
Top