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

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.

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

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


Gord Dibben MS Excel MVP

On Tue, 1 Dec 2009 18:48:21 -0800 (PST), skyexcel
wrote:

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.

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

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--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"skyexcel" wrote:

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.
.

hyperlink not working in excel 2007, if worksheet is hide orhidden
 

On Dec 3, 3:22*am, Gord Dibben <gorddibbATshawDOTca wrote:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
* * With Sheets("Sheet1")
* * * * .Visible = True
* * * * .Select
* * End With
End Sub

Gord Dibben *MS Excel MVP

On Tue, 1 Dec 2009 18:48:21 -0800 (PST), skyexcel
wrote:



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.- Hide quoted text -

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