D
Dan
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
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