Hyperlink-Pawan

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi...
I have one worksheet. My requirement is :
Upon clicking cell A1, portion through cell A5 to E15 should get selected,
in the same worksheet. I want to create hyperlink in cell A1. But I dont know
how to do this? Can anybody help me.
Thanks in advance.

-Pawan
 
use the following code in the module of the concerned sheet:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
Range("A5:E15").Select
End If
End Sub

Mangesh
 
Back
Top