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.
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: