Did you say you changed the name of Sub Workbook_SheetCalculate? Excel
finds it by its name. And you did copy it into the ThisWorkbook module,
right?

--
Jim Rech
Excel MVP

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

Something is not right. For one thing, if Sub Total is in ThisWorkbook then
it would appears as "ThisWorkbook.Total" not "Total" in the Macros dialog.

Can you send if an example file that has this problem? Maybe delete all but
one sheet and most of the formulas on that last sheet.

--
Jim Rech
Excel MVP

Yes, it did show as "ThisWorkbook.total"....

I was able to do some trial-and-error troubleshooting on
it last night and believe I found the solution. It's hard
for me to say exactly what the problem was, because of the
way I was approaching the problem.

I do appreciate your help.
Rich

-----Original Message-----
Something is not right. For one thing, if Sub Total is
in ThisWorkbook then
it would appears as "ThisWorkbook.Total" not "Total" in
the Macros dialog.