Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying the "Calculating Cells n%"
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying the "Calculating Cells n%"
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" wrote in 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying the "Calculating Cells n%"
-----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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help displaying "Maximum" or "Minimum" if cell is max or min in a group? | Excel Discussion (Misc queries) | |||
Chart displaying "blank" cells? | Charts and Charting in Excel | |||
"don't update" links & calculating cells | Links and Linking in Excel | |||
not displaying "FALSE" in cells | Excel Worksheet Functions | |||
Inserting new data before "calculating cells" is done??? | Excel Discussion (Misc queries) |