hyperlink not working in excel 2007, if worksheet is hide or hidden

[skyexcel]

I am facing this issue, need someone to share how to get the hyperlink
working on excel 2007 if i hide or hidden the worksheet.

 

[Gord Dibben]

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
With Sheets("Sheet1")
.Visible = True
.Select
End With
End Sub


Gord Dibben MS Excel MVP

 

[ryguy7272]

Unhide the sheet, do your operation, and then make it hidden again:

Sub HideSheets()
'Set worksheet to Very Hidden so that it can only be unhidden by a macro
Worksheets("Sheet1").Visible = xlSheetVisible
'...do your stuff here.......
Worksheets("Sheet1").Visible = xlSheetVeryHidden
End Sub

HTH,
Ryan--

 

[skyexcel]

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    With Sheets("Sheet1")
        .Visible = True
        .Select
    End With
End Sub

Gord Dibben  MS Excel MVP



- Show quoted text -

I am not very good at visual basics, what do I have to do next next
after programming code on the visual basics code?
can give instructions! thanks a lot!

 

[Julian Schubert]

Hello everybody,

sorry I am an Excel Rookie!!

I have the same problem, but do not understand the answers.

So again:

I want to create a Hyperlink from Sheet 'A' to HIDDEN Sheet 'B'


how can I manage that in Excel 2007?

Thank you...



BE SMART! WORK HARD! HAVE FUN!