Calculating cells.
 

I have a workbook with a lot of data calculation, and as a result when
you change a drop down menu the workbook recalculates for a while.
Many of my users, don't see the Stats Bar where it says "Calculating:
_%". Is there any way to show a status bar showing that progress (I
have done status bar's in the past, but i dont know of any way to pass
that % to the status bar), or is there any way in vba if I myself do a
manual calc (i.e. F9) to keep track of the progress?