Kate,

you could try using the worksheet change event to trigger
the macro. Something like this should work:

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$A$1" and Target.value = "B" Then
Application.EnableEvents = False
Call KatesMacro()
Application.EnableEvents = True
End If

End Sub

Pete