Worksheet.Calculate only gets called after a sheet is recalculated: Add a
volatile function ( for example =Time()) to the worksheet in your addin to
make it recalculate at each application recalculation..
or use application level events to trap the calculate event. This is more
complex: see Chip Pearson's site
http://www.cpearson.com/excel/AppEvent.htm
HTH
Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com
"kikde" wrote in message
...
the problem is: if have code in the sheetcalculate event of the addIn!
if i have a active workbook and press F9, this event handler should be
raised. but it won't, only the sheetcalculate of the active workbook will
be
called.
"kikde" wrote:
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