how to activate macro from cell
 

Can I activate macros from cell by clicking it??

how to activate macro from cell
 

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

"artzuka" wrote:

Can I activate macros from cell by clicking it??

how to activate macro from cell
 

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

"artzuka" wrote:

Can I activate macros from cell by clicking it??