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

  • Thread starter Thread starter skyexcel
  • Start date Start date
S

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.
 
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
With Sheets("Sheet1")
.Visible = True
.Select
End With
End Sub


Gord Dibben MS Excel MVP
 
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--
 
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 -
Click to expand...

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!
 
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!
 
Back
Top