Yes, I copied it to the "this workbook" module.

"Sub Workbook_SheetCalculate" wouldn't run, but if I
changed it to "Sub Total", I can go to the Macro dialog
ender "tools", select the macro called "Total" and
hit "run" and it would work properly.

The problem seems to be with the "SheetCalculate" event...

Rich