Creating a progress bar

Help wanted on displaying a Progress Bar.

I am running a macro in VBA version 2007 which is doing calculations in a workbook. These are taking a long time and I want to show a 'Calculations Progressing' bar similar to those shown on downloading etc.
Originally, I had set Excel invisible which increased the computing speed dramatically. I have not yet succeeded in producing a Progress Bar and I have been trying to achieve one by setting all but one worksheet as hidden and putting the bar on the one sheet that remains visible. This does not work because a) the calculations show through the visible sheet and b) the bar I create does not appear until the calculations are finished which defeats the object rather!

I feel sure that there should be a built-in facility to do this somewhere, but I cannot find it. An alternative I thought might work was to use Userforms to display the information, but I have not found a way to do it.

I hope you can help,thanks.

Try reading this discussion:

http://www.mrexcel.com/archive/VBA/18536.html