AFTER Calculate Event

[Guest]

After my worksheets have been calculated, I need to display a message box
with particular information.

Went to the VBA code sheet for my worksheets, but there is no AFTERCalculate
event listed.

I know sometimes not all events are listed, IS there a aftercalculate event
available for me to use (either worksheet or workbook level).

Tanx.

 

[Gary Brown]

John,

As far as I know there is no 'AfterCalculate' event.

Why not calculate the worksheet then have your processing code immediately
after that? That way you ensure that the worksheet has been calculated
prior to your code running. For example...

Calculate
your code here

Hope that helps,
Gary Brown

 

[David McRitchie]

but there is a

Worksheet_Calculate Event (#calculate)
http://www.mvps.org/dmcritchie/excel/event.htm#calculate

and if you use a message box after every recalculation you
won't get anything done.

 

[Guest]

"Calculate" is set to manual for the workbook. I'll check this out.

 

[Guest]

The calculation is being initiated manually, not by code.