Really? A Worksheet_Change routine in the ThisWorkbook module will work for every worksheet? That's cool, I never knew. I don't think I've ever had to have the same Worksheet_Change logic for every worksheet in a workbook, so (I realize now) I was just assuming.
Wait—what happens if I have a Worksheet_Change procedure in both modules, ThisWorkbook and a worksheet? Does Excel get upset, or does it just let the worksheet override the workbook?
|