Thanks Norie, workbook_sheetchange is a step closer to what I want. So you mentioned using sheet_calculate, do I have to user it on every sheet then?