Displaying the "Calculating Cells n%"

[Kevin]

Is it possible to display the Calculating Cells n% from
the status bar as a progress bar?

If not is there a way to make it more visible.

Here is more detail on my issue.

When the user opens the workbook a dialog box appears
asking them to selet a cost center then press ok. There
are multiple sheets with multiple formulas that use the
cost center they select. It takes less than a min for the
workbook to calculate, but during this time they are
unable to press "ok". My concer is they may miss the
calculating message in the staus bar, or have it turned
off.

Any way to make this more prominet?

thanks

 

[Charles Williams]

Hi Kevin,

AFAIK there is no way of tapping into the % calcualting message in the
statusbar.
In Excel 2002 you can check Application.calculationstate to see if excel is
still calculating

I would do something like this:

Application.calculation=xlcalculationmanual
frmChooseCostCentre.show

then in the code behind OK button on the form

Msbox "Calculateing Now, please wait for Calculation finished"
Application.calculation=xlcalculationautomatic
Msgbox "Calculation finished"

hth

Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com

 

[Kevin]

-----Original Message-----
Is it possible to display the Calculating Cells n% from
the status bar as a progress bar?

If not is there a way to make it more visible.

Here is more detail on my issue.

When the user opens the workbook a dialog box appears
asking them to selet a cost center then press ok. There
are multiple sheets with multiple formulas that use the
cost center they select. It takes less than a min for the
workbook to calculate, but during this time they are
unable to press "ok". My concer is they may miss the
calculating message in the staus bar, or have it turned
off.

Any way to make this more prominet?

thanks
.
Charles that will work just fine, gives them a heads up

that the sheet is calculating Thanks