When you press F9 Excel does a Recalculate of all open workbooks, not a
Sheet calculate: did you mean Shift-F9 (recalculates all selected sheets)?
If so then Shift-F9 will not trigger a recalc of sheets in an addin because
the sheets will not be selected.

Why do you think that pressing F9 will not trigger a recalc of sheets in an
addin? It does trigger a recalc of addin sheets in my system: try adding a
volatile function to a sheet in your addin and putting some code
(debug.print "Hello") in the worksheet_calculate sub of that sheet. You will
see "Hello" in the immediate pane every time you press F9.

regards
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com


"kikde" wrote in message
...
Hi,
i have a problem with an addin.
the sheetCalculate-event won't be fired for the add-In, so the code in the
event handler of the add-inn won't be started...

few more infos:
- Other events like WorkbookActivate will be fired for the add-in
- sheetCalculate will be fired for the active workbook (only for testing,
there is no code
- no other add-inns are started