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.
The Excel VBA procedure in the workbook below shows the workings.