Hi
Yes, you can do that by running a macro based on the value of a cell. You will set the cell value using a trigger. Please see the attached files as an example.
I can’t upload a .xlsm file, so have renamed it .xls. Once you have downloaded it, please rename it .xlsm (it’s clean!)
The Excel file contains a recorded macro called BackMatched which simply puts the text “back matched” in cell Sheet1!E6
The VBA code below checks cell D2 and if the value is 1 it runs the BackMatched macro
The trigger file writes “1” to cell D2 when the fav back_matched is greater than 0
Paste the code into the Visual Basic of the sheet you want.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$2" And Range("D2") = 1 Then
Call BackMatched
End If
End Sub