check if excel sheet in manual calc mode

Dan

Guest

Posts: n/a

23rd Jan 2008

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.

« cell color condition | searching for shapes »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
check if excel sheet in manual calc mode	Dan	Microsoft Excel Programming	1	23rd Jan 2008 05:33 AM
Calc = Manual & Do Not Calc b/4 SAVE	=?Utf-8?B?S2Vu?=	Microsoft Excel Misc	0	3rd Oct 2007 02:28 PM
Manual calc for one sheet, auto calc for another	Hall	Microsoft Excel Discussion	1	17th Apr 2007 03:52 AM
Open CSV causes calculation in manual calc mode	kunkletown@comcast.net	Microsoft Excel Misc	0	25th Jul 2006 09:22 PM
Spreadsheet changes from auto calc to manual calc - HELP!	=?Utf-8?B?VGVpamE=?=	Microsoft Excel Worksheet Functions	2	19th Aug 2004 11:34 PM