| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a test to determine whether a workbook needs to be calculated be performed?
Thanks works like a charm
"Charles Williams" wrote in message ... Try Application.CalculationState Charles ___________________________________ The Excel Calculation Site http://www.decisionmodels.com "Breck" wrote in message ... I have a workbook that has manual calculation turned on. I need to run a macro that only runs if the workbook needs to be calculated on the active sheet. I have found this code Application.CalculationVersion < activeworkbook.CalculationVersion that appears to perform this test but it always returns a false value whether the calculation indicator show calculate or not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does t-test with unequal variance determine df? | Excel Worksheet Functions | |||
| How do I determine if a workbook is a template? | Excel Programming | |||
| Need macro to run when workbook is calculated | Excel Programming | |||
| Max sheets in a workbook or max # of calculated cells | Excel Discussion (Misc queries) | |||
| Can Excel2002 determine if a calculated date is a business day? | Excel Worksheet Functions | |||
Threaded Mode
