Ciao prova ad inserire nel foglio interessato questo:
Private Sub Worksheet_Change(ByVal Target As Range)
Const sTargetAddress As String = "B8"
On Error GoTo Esci
Application.EnableEvents = False
With Target.Cells(1, 1)
If .Address(False, False) = sTargetAddress Then
Call macro_conta
End If
End With
RiprendiErrore:
Application.EnableEvents = True
Exit Sub
Esci:
MsgBox "Errore n. " & Err.Number & vbCrLf & _
Err.Description, vbCritical, "Errore"
Resume RiprendiErrore
End Sub
Sub macro_conta()
MsgBox "Ciao... ora devo contare"
End Sub