Ok, I have super simple code and it refuses to work. I've used this code several times before on other workbooks and has done wonderfully.
Sub Worksheet_Change(ByVal Target As Range)
If Target.Address.Value = "$A$1" Then
Call MyMacro
End If
End Sub
Application.EnableEvents = True (I've triple...