Thread: check if excel sheet in manual calc mode
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
  
Posts: 866
Default check if excel sheet in manual calc mode
Can we check all the time if excel sheet in manual calc mode
I have tried :
Function MyCalcStatus()
Application.Volatile
If Application.Calculation = -4105 Then MyCalcStatus = "Auto"
If Application.Calculation = -4135 Then MyCalcStatus = "Manual"
End Function

But because nothing in the sheet get calculated in Manual mode the Volatile
does not get triggerd either.
Reply With QuoteReply With Quote