Hello,

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

kalpesh wrote:

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

One way is the Worksheet_SelectionChange event. Place this in the worksheet's
class:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If "$A$1" = ActiveCell.Address Then
'your code here
End If
End Sub

If you want your code to run when A1 is the only thing selected, change
ActiveCell.Address to Target.Address.

--
I can't believe he would even THINK of something like... like...
Oh, who the hell am I kidding? Yes I can.

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

Hello,

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