View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default SheetCalculate (F9) does not reach the excel-addin

Sheet calculate would not fire for the add-in as that is not the active
sheet.

Why are you having calculations in the add-in, not on the target worksheet?
Perhaps you could re-design to remove it from the add-in.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"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