how to detect change of calculation-option

[Joerg Lensing]

Hi NG,
If a user changes the dialog EXTRA/OPTIONS/CALCULATION, I want to start
a Makro. How can I do this? (Excel 2003)

tx Jörg

 

[Bernie Deitrick]

Jörg,

You can check with and event. For example, checking after the user changes the selection:

In a standard module:

Option Explicit
Public CalcMode As XlCalculation


In the codemodule of the ThisWorkbook object:

Private Sub Workbook_Open()
CalcMode = Application.Calculation
End Sub

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
If Application.Calculation <> CalcMode Then
MsgBox "Calc Mode has changed"
CalcMode = Application.Calculation
End If
End Sub


HTH,
Bernie
MS Excel MVP


Hi NG,
If a user changes the dialog EXTRA/OPTIONS/CALCULATION, I want to start
a Makro. How can I do this? (Excel 2003)

tx Jörg