Need Calculations Done Event
 

After my workbook finishes re-calculating the entire Workbook, I want to
re-draw some shapes based on the results of the recalculation. I was unable
to find any event signaling that the workbook calculations are done. I don't
want to use the Worksheet_Calculate Event because it is triggered every time
any Worksheet is recalculated. My calculations have always involved lots of
iteration. Any ideas?

Need Calculations Done Event
 

there's no workbook level calculate event
you'll need to control the calculation to achieve this
ie force each sheet or range to calculate in VBA --- then when the routine
is done, you'll know when to do the next bit


"MachAngle" wrote in message
...
After my workbook finishes re-calculating the entire Workbook, I want to
re-draw some shapes based on the results of the recalculation. I was
unable
to find any event signaling that the workbook calculations are done. I
don't
want to use the Worksheet_Calculate Event because it is triggered every
time
any Worksheet is recalculated. My calculations have always involved lots
of
iteration. Any ideas?