Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning calculation status
I have a large spreadsheet model set to manual calculation. I want to be able
to identify in a cell (as opposed to on the status bar) whether the model needs to be updated using F9 so that the key output report highlights whether the model is up to date. Any ideas ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning calculation status
Application.CalculationState will give you the answer, but you would need
some event or user action such as clicking a button to retrieve it and put it into a cell. Maybe selecting the key output report sheet. regards Charles Williams Decision Models "Phil H" <Phil wrote in message ... I have a large spreadsheet model set to manual calculation. I want to be able to identify in a cell (as opposed to on the status bar) whether the model needs to be updated using F9 so that the key output report highlights whether the model is up to date. Any ideas ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning calculation based on number | Excel Worksheet Functions | |||
Calculation appear on status bar when in autocalc mode | Excel Discussion (Misc queries) | |||
Nested If statements returning a sum calculation | Excel Worksheet Functions | |||
STATUS BAR LENGHT OF CALCULATION BOX | Excel Discussion (Misc queries) | |||
returning a sheet to blank orginal status? | Excel Discussion (Misc queries) |