When you do an activesheet.calculate any formulae in other sheets that refer
to the activesheet do not get updated (as well as volatile formulae on the
other sheets), and the cells on the activesheet that were calculated will
also be recalculated at the next calculate.

If an F9 recalculation takes much longer than the ActiveSheet.calculate
(Shift-F9) then either you have a lot of volatile formulae on the other
sheets or the other sheets DO depend on the Activesheet.

If you want to be reminded about the status of the calculation you could put
a message in the status bar after the Sheet.Calculate
Application.StatusBar="Sheet '" & activesheet.name & "' Calculated"

and then Trap F9 using Onkey to do an Application.Calculate and
Application.Statusbar=False to reset the message.


Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Steven" wrote in message
...
I have a situation where the calculation takes too long and so I put this
in
the ThisWorkbook module "SheetChange" event:

ActiveWorkbook.ActiveSheet.Calculate

This makes the calculation much faster and I am confident everything is ok
becuase all that needed to be calculated was the current sheet but the
status
bar now reads...:
"Ready Calculate"
:.... becuase there was not a full calculation done.

Are there any good methods of how to handle this. It is more of a
communications issue to myself of the status of the calculation in the
overall excel system. [Note: I do not want to always be doing a full
calculate becuase of the time it takes but, as an additional note, on the
BeforePrint event I do have a full calculate becuase I cannot take the
chance
that something is not fully calculated when printed.]

Thank you for your help,

Steven