Need Calculations Done Event

[MachAngle]

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?

 

[Patrick Molloy]

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