Well, you can create a function for the Workbook_Change event that wil
call the other functions when there is a change to the sheet. Be sur
to start the function off with

Application.EnableEvents = False

because if you don't, any changes made will retrigger the same event.
End the function with

Application.EnableEvents = True

Let me know if you need more help. - Piku

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