how to detect change of calculation-option
 

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

how to detect change of calculation-option
 

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


"Joerg Lensing" wrote in message
oups.com...
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