Excel Workbook Level VBA Change Event

The following Excel VBA article will trap a change in every sheet on your workbook.  Rather than putting a worksheet change event on each sheet, this procedure should be put in the Thisworkbook module.  This assumes all sheets in the workbook are templates and you want to trap a change and perform the same action on each sheet when this change occurs.  

The following is a very simple procedure which will turn the cell Red when there has been a change in cells A10:A15.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Not Intersect(Target, Range("A10:A15")) Is Nothing Then 'VBA change event for all sheets
Target.Interior.Color=vbRed
End If
End Sub

The Excel VBA procedure in the workbook below shows the workings.