Auric has pointed you to a method use a selection chamge event.

There are other event types you could use if you choose

BeforeRightClick

BeforeDoubleClick

Sample code..............................

Private Sub Worksheet_BeforeDoubleClick( _
ByVal Target As Excel.Range, Cancel As Boolean)
Select Case Target.Address(False, False)
Case "A1"
Cancel = True
MyA1Macro
Case "B1"
Cancel = True
MyB1Macro
Case "C1"
Cancel = True
MyC15Macro
End Select
End Sub


Gord

On Mon, 06 Feb 2012 11:19:23 -0600, kalpesh
<(E-Mail Removed)> wrote:

>Hello,
>
> it is possibel that when in sheet1 a1 cell is active to run macro

Please make correction to MyC15Macro

Should read MyC1Macro


Gord

On Mon, 06 Feb 2012 12:11:14 -0800, Gord Dibben <(E-Mail Removed)>
wrote:

>Auric has pointed you to a method use a selection chamge event.
>
>There are other event types you could use if you choose
>
>BeforeRightClick
>
>BeforeDoubleClick
>
>Sample code..............................
>
>Private Sub Worksheet_BeforeDoubleClick( _
> ByVal Target As Excel.Range, Cancel As Boolean)
> Select Case Target.Address(False, False)
> Case "A1"
> Cancel = True
> MyA1Macro
> Case "B1"
> Cancel = True
> MyB1Macro
> Case "C1"
> Cancel = True
> MyC15Macro
> End Select
>End Sub
>
>
>Gord
>
>On Mon, 06 Feb 2012 11:19:23 -0600, kalpesh
><(E-Mail Removed)> wrote:
>
>>Hello,
>>
>> it is possibel that when in sheet1 a1 cell is active to run macro