VBA for confirming Calculation status

[Guest]

Friends,

RE: Excel 2000

In Tools/Options/Calculation there are radio buttons to choose either
"Manual" or "Automatic" calculation.

I want to display the status (value) of this calculation mode in a message
box. Is this possible, and if so, what is the syntax for assigning this value
to a variable.

Dim strVar as String
strVar = [?? - code that delivers status of Calc mode - either "manual" or
"automatic"].

Thanks for your help ...

Bill Morgan

 

[Dirk Goldgar]

Friends,

RE: Excel 2000

In Tools/Options/Calculation there are radio buttons to choose either
"Manual" or "Automatic" calculation.

I want to display the status (value) of this calculation mode in a
message box. Is this possible, and if so, what is the syntax for
assigning this value to a variable.

Dim strVar as String
strVar = [?? - code that delivers status of Calc mode - either
"manual" or "automatic"].

Thanks for your help ...

Bill Morgan

I think you'd better post your question in one of the Excel newsgroups,
maybe <microsoft.public.excel.programming>. This one is for questions
about programming Microsoft Access, the database product.