Class MultiThreadedCalculation (Excel VBA)

Returns or sets the concurrent calculation mode. To use a MultiThreadedCalculation class variable it first needs to be instantiated, for example

Dim mtc as MultiThreadedCalculation
Set mtc = Application.MultiThreadedCalculation

Enabled

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

Application.MultiThreadedCalculation.Enabled = True

ThreadCount

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

Application.MultiThreadedCalculation.ThreadCount =

ThreadMode

Returns or sets the thread mode for the specified MultiThreadedCalculation object. Possible return 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.

Application.MultiThreadedCalculation.ThreadMode = xlThreadModeAutomatic