View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bwilk77 bwilk77 is offline
external usenet poster
 
Posts: 15
Default Display message while calculating forumlas

I have a worksheet (Excel 2007) that has to recalculate a lot of cells when a
user changes the value in one of the input cells, and it takes a decent
amount of time for the calculations to complete. In the status bar it
displays "Calculating... (x%)", but I would like to have this be more
prominent so the user knows to wait for the formulas to finish their
calculations.

Is there a way to display a message in the middle of the screen that says
"Calculating..." while the formulas recalculate?

Thanks,
Brad