Running macro from a worksheet

[sdohertyccb]

I know this should be a fairly easy answer, but I am having a "brain cramp" on this. I want a sub to run on a worksheet when the workbook calculates. I have the macro in the worksheet module (I have tested it and it runs fine when I manually run it), but it doesn't seem to fire when I run the reports (lots of other macros and forms). I want this routine to execute as the file is saving but before the program prints. Is there an event comand that I should be using? Any thoughts?
Thanks in advance for your help.

 

[VoG]

Try like this in the sheet's code module

Private Sub Worksheet_Calculate()
'code to call your macro
End Sub

 

[sdohertyccb]

I will give it a try. Thanks.