After.Calculate event

[Sam Hamman]

Hi, I have a large spreadsheet with a number of calculated cells.

When I click calculate nothing happens for ages then the % complete
slowly increases....but I am never sure when the calculations has been
completed.

I have been told that the after.calculate event coulc help me but I
have no idea how it works or how I could implement it.

Can anyone help please

thanks

Sam
MS Excel 2007

 

[Jim Cone]

The "after.calculate" event doesn't exist in Excel. I've never heard of it.
Suggest you pack your lunch and spend some time at Charles Williams website...
http://www.decisionmodels.com/index.htm

 

[Sam Hamman]

Thanks Jim.....it was mentioned on the net so i thought i would ask
the experts...

Sam