Marco to automatically highlight cell when it changes

[RedRooster]

New at this. I have 4 sheets in a workbook that all contain the exact macro code. The macro code it to identify and highlight yellow all cells on each of the sheets when a change takes place. One of the sheets works fine all the time. The other 3 initially work but for some reason start to throw a 104 Application-defined or Object-defined error. How do I get the 3 not working to work along with the one that does work?

Sub Worksheet_Change(ByVal Target As Range)

Range(Target.Address).Interior.Color = RGB(250, 250, 0)

End Sub

 

[RedRooster]

I believe the issue could be the levels of restriction/protection may not be same for each sheet.

 

[James006]

Hi,
Much easier to delete all individual codes in each Sheet module and have in ThisWorkbook module

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
   Target.Interior.Color = RGB(250, 250, 0)
End Sub