Hello:
Im currently writing a pretty simple macro where when I select a particular cell it runs a macro automatically. When I click on the target cell simply nothing happens. I have turned on events using ctrl+G and typing Application.EnableEvents = True. Here is my code and any help is welcome.
Code
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim KeyCell As Range
Set KeyCell = Range("B43")
If Target.Address = KeyCell Then
Call Macro1
End If
End Sub
In addition, here is the Macro1 I am trying to call: