check if excel sheet in manual calc mode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan - 23 Jan 2008 01:44 GMT

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 to this Message

ilia - 23 Jan 2008 05:33 GMT

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

> Is it possible to check all the time if a sheet has by mistake been switched
> to manual calc?
[quoted text clipped - 10 lines]
> Many thanks,
> Dan

Reply to this Message