Put this with your code into the code for "ThisWorkbook" and it will run
every time there is a change to the workbook. Careful though because
if the code itself changes the sheet, that change will trigger the same
process

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)

End Sub

As for Cell background color:

Cells(1, 3).Interior.ColorIndex = 6

6 = Yelow

Other numbers represent other colors. - Pikus


---
Message posted from http://www.ExcelForum.com/