Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if excel sheet in manual calc mode
Is it possible to check all the time if a sheet has by mistake been switched
to manual calc? I have tried the below but obviously not working as when we are in Manual calc no calc is done to triger the volatility of the function. Function MyCalcStatus() Application.Volatile If Application.Calculation = -4105 Then MyCalcStatus = "Auto" If Application.Calculation = -4135 Then MyCalcStatus = "Manual" End Function Many thanks, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if excel sheet in manual calc mode
Could use either change or selection_change worksheet events. Also,
you can use these two constants, for better readability: Application.Calculation = Excel.xlCalculationAutomatic Application.Calculation = Excel.xlCalculationManual On Jan 22, 8:44*pm, Dan wrote: Is it possible to check all the time if a sheet has by mistake been switched to manual calc? I have tried the below but obviously not working as when we are in Manual calc no calc is done to triger the volatility of the function. Function MyCalcStatus() *Application.Volatile *If Application.Calculation = -4105 Then MyCalcStatus = "Auto" *If Application.Calculation = -4135 Then MyCalcStatus = "Manual" End Function Many thanks, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual Calculation in Excel 2007 with Calculate mode set to Automatic | Excel Worksheet Functions | |||
MODE calc where more than one mode number! | New Users to Excel | |||
Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Automatic Manual Calc When Opening!! | Excel Programming |