Unhide row on hyperlink click

[adamsm]

Hi,

How could I unhide rows 8:13 when I click the hyperlink on C7.

Suppose I have the text "me" in cell C7, when I click the hyperlink I want the rows to get unhidden.

Any help on this would be kindly appreciated.

 

[CharlesChuckieCharles]

Hi,

How could I unhide rows 8:13 when I click the hyperlink on C7.

Suppose I have the text "me" in cell C7, when I click the hyperlink I want the rows to get unhidden.

Any help on this would be kindly appreciated.

Try this

Places this in the SheetModule

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$C$7" Then
   If Rows("8").Hidden = True Then
      ActiveSheet.Rows("8:13").Hidden = False
    
   Else
      ActiveSheet.Rows("8:13").Hidden = True
   End If
End If
   
End Sub

This toggles hidded/unhidden based on the cell C7 getting the focus

It only changes when you click in to c7 the first time

so click somewhere else and then back into C& and it will toggle

 

[Gary McMaster]

Maybe the follow hyperlink event:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

If Target.Parent.Address = "$C$7" Then ActiveSheet.Range("8:13").Rows.Hidden = False

End Sub

Gary