Automatically run a routine

[hartless43]

This will be easy for someone (not me) but the below Macro is run by a Macro Button. I would like for it to run automatically as soon as cell "G11" is 81. I think it can be done via Function or a WorkSheet_Change but I ain't that good at creating a function or whatever is needed to make it work. This is a Sudoku thing.

Sub ShowMistakes()
If Range("G11") = 81 Then
Range("W13") = "Yes"      '/This is set to "NO" while playing Sudoku and Mistakes are not shown until "G11" is 81
End If
End Sub

Thanks

 

[Micron]

try

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Range("G11") = 81 Then
     Range("W13") = "yes"
Else
     Range("W13") = ""
End If

Application.EnableEvents = True
End Sub

Usually I advocate an error handler when cycling application properties but didn't include one in this simple case.

 

[hartless43]

Thanks, Micron, that was easy and it's what I needed.

 

[Micron]

You're welcome & thanks for the recognition.