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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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
|
Similar Threads
