VBA for confirming Calculation status

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bill_morgan_3333 - 30 Nov 2004 18:49 GMT

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

Reply to this Message

Dirk Goldgar - 30 Nov 2004 22:12 GMT

> Friends,
>
[quoted text clipped - 14 lines]
>
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message