VBA for confirming Calculation status

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
bill_morgan_3333 said:
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
Click to expand...


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.
 
Back
Top