how to activate macro from cell

M

Mike H

Hi,

You could do this. Right click your sheet tab, view code and paste this in
and then try selecting A1

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
MyMacro
End If
End Sub

Sub MyMacro()
MsgBox "You Did it"
End Sub

Mike
 
A

artzuka

Thanks, It works well...

"Mike H" kirjoitti:
Hi,

You could do this. Right click your sheet tab, view code and paste this in
and then try selecting A1

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$1" Then
MyMacro
End If
End Sub

Sub MyMacro()
MsgBox "You Did it"
End Sub

Mike
Click to expand...
 
Top