Unhide row on cell double click

[adamsm]

Hi,

How could i write a doubleclick event code to unhide row 12 when the user double clicks cell I10

Any help would be kindly appreciated.

Thanks in advance.

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Address(False, False) = "I10" Then
    Cancel = True
    Rows(12).Hidden = False
End If
End Sub