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