Class MultiThreadedCalculation (Excel VBA)

Returns or sets the concurrent calculation mode.

Enabled

The Enabled property allows MultiThreadedCalculation objects to be enabled or disabled at run time.

Parent

Returns the parent object for the specified object. Read-only.

ThreadCount

Gets the total count of the process threads that are a part of the specified MultiThreadedCalculation object.

ThreadMode

Returns or sets the thread mode for the specified MultiThreadedCalculation object.

Possible Values are xlThreadModeAutomatic - Multi-threaded calculation mode is automatic, xlThreadModeManual - Multi-threaded calculation mode is manual.

You can set the thread mode to either xlThreadModeAutomatic or xlThreadModeManual.