Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Calculation State
firstly, thanks for the invisible range names advice -
thats solved. is it possible to detect the calculation state of a workbook such that the macro will only make it recalculate if it requires it. I run Excel 2000. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Calculation State
Chris,
The following code is from Myrna Larson: Application.ScreenUpdating = False SaveCalcMode = Application.Calculation Application.Calculation = xlCalculationManual ' your code here Application.Calculation = SaveCalcMode Application.ScreenUpdating = True When you get to the "your code here" line, calculation will be set to manual, regardless of what it was before. Within your code, you can calculate the entire workbook Application.Calculation = xlCalculationAutomatic or a specific sheet Worksheets("Sheet1").Calculate With the coding above, Excel will return to whatever calculation state it was in before you ran the code. John Chris Gorham wrote: firstly, thanks for the invisible range names advice - thats solved. is it possible to detect the calculation state of a workbook such that the macro will only make it recalculate if it requires it. I run Excel 2000. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Calculation State
Sorry,
nice try - but sometimes I have a very large model and I only want to recalculate it if it needs to be - I need to detect the calculation status (assuming that the model is already set to manual recalc) Chris -----Original Message----- Chris, The following code is from Myrna Larson: Application.ScreenUpdating = False SaveCalcMode = Application.Calculation Application.Calculation = xlCalculationManual ' your code here Application.Calculation = SaveCalcMode Application.ScreenUpdating = True When you get to the "your code here" line, calculation will be set to manual, regardless of what it was before. Within your code, you can calculate the entire workbook Application.Calculation = xlCalculationAutomatic or a specific sheet Worksheets("Sheet1").Calculate With the coding above, Excel will return to whatever calculation state it was in before you ran the code. John Chris Gorham wrote: firstly, thanks for the invisible range names advice - thats solved. is it possible to detect the calculation state of a workbook such that the macro will only make it recalculate if it requires it. I run Excel 2000. Thanks . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detecting Calculation State
Hi Chris,
In Excel 2002 you can check: if application.calculationstate=xlpending then application.calculate endif before xl2002 there is no good method: you can check if the workbook has been changed by checking the Workbook.Saved property, but that is a bit oversensitive. hth Charles ______________________ Decision Models The Excel Calculation Site www.DecisionModels.com "Chris Gorham" wrote in message ... Sorry, nice try - but sometimes I have a very large model and I only want to recalculate it if it needs to be - I need to detect the calculation status (assuming that the model is already set to manual recalc) Chris -----Original Message----- Chris, The following code is from Myrna Larson: Application.ScreenUpdating = False SaveCalcMode = Application.Calculation Application.Calculation = xlCalculationManual ' your code here Application.Calculation = SaveCalcMode Application.ScreenUpdating = True When you get to the "your code here" line, calculation will be set to manual, regardless of what it was before. Within your code, you can calculate the entire workbook Application.Calculation = xlCalculationAutomatic or a specific sheet Worksheets("Sheet1").Calculate With the coding above, Excel will return to whatever calculation state it was in before you ran the code. John Chris Gorham wrote: firstly, thanks for the invisible range names advice - thats solved. is it possible to detect the calculation state of a workbook such that the macro will only make it recalculate if it requires it. I run Excel 2000. Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
Detecting Calc On or Off | Excel Discussion (Misc queries) | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
Detecting absentees | Excel Discussion (Misc queries) |