View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Antonio Elinon[_2_] Antonio Elinon[_2_] is offline
external usenet poster
 
Posts: 14
Default SheetCalculate (F9) does not reach the excel-addin

You can try to fire the sheetCalculate event via another event.
There are two main reasons why you would want to re-calculate in your add-in:
1. At the beginning of your process - therefore you could fire a manual
calculate inside the WorkbookActivate event.
2. During processing - this means you have changed a cell value in the addin
sheet and wish to recalculate based on the new cell value. Since an addin is
usually hidden, this should mean that you know which cell changed. Therefore
you can use the Workbook_SheetChange event to include a manual recalculation
code.

Kind Regards,
Antonio Elinon

"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