ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   check if excel sheet in manual calc mode (https://www.excelbanter.com/excel-programming/404800-check-if-excel-sheet-manual-calc-mode.html)

dan

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.


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com