User FAQs

1) Is it possible to prevent the calculation from being interrupted ?
Yes. There are two ways this can be achieved:
Using the CalculationInterrupting property.

Application.CalculationInterrupting = xlCalculationInterruptKey.xlNoKey. 

If you are running from VBA using the Application OnTime.

Application.OnTime MacroName 

2) What does the Range.Calculate method do ?
Smart Recalculation of the specified range.

Range("A1:D20").Calculate 

3) What does the Range.CalculateRowMajorOrder method do ?
Smart Recalculation of the specified range ignoring any forward references or within range dependencies.

Range("A1:D20").CalculateRowMajorOrder 

4) Is there a way in code to trigger a recalculation of the active sheet only ?
Togglying the EnableCalculation property and then recalculating.

ActiveSheet.EnableCalculation = False 
ActiveSheet.EnableCalculation = True 
Activesheet.Calculate 

5) Is there a way to check the calculation state ?
Yes. You can use the CalculateState property.

Application.CalculationState 

6) What does the Workbook.ForceFullCalculation property do ?

Workbook.ForceFullCalculation = True 

Returns or sets the workbook to forced calculation mode.
This property will be reset when Excel is restarted or the workbook is closed.
When you want every calculation of the workbook to be a full calculation.
When this property is set to True the calculation time for data tables will increase significantly.

7) When would you use the Workbook.ForceFullCalculation property ?
If a workbook has a large number of complex dependencies that takes ages to load or when a recalculation takes longer than a full calculation.

8) Write code that will trap the F9 events and redirect it to a subroutine.

Application.OnKey "{F9}", "HandleF9" 
Application.OnKey "+{F9}", "HandleShiftF9" 
Application.OnKey "^+{F9}", "HandleCtrlShiftF9" 
Application.OnKey "%^+{F9}", "HandleAltCtrlShiftF9" 

9) What is the Range.Dirty method ?
Designates a range to be recalculated the next time a recalculation is performed.

Range("A1:B10").Dirty = True