Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
apply cell change event to single column - WorksheetChange Event | Excel Programming | |||
Click event on menu item is lost after first time firing of the event | Excel Programming | |||
MsgBox in Enter event causes combobox not to run Change event | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |