Put the code in the calculate event at the workbook level. Or call the code
from the calculate event at the workbook level.

--
Regards,
Tom Ogilvy

"Dale Cox" wrote in message
...
I have created a macro that performs computations of
fields across several workbooks. How do I get this to
automatically execute every time the workbook perform the
auto-calculation function?

Thanks.