SheetCalculate (F9) does not reach the excel-addin
If the code in the sheetcalculate of the active workbook is yours, then
revise this to add a direct call to the sheetcalculate of the addin.
If it is not yours to revise, then it is not possible as the add-in has no
way of knowing about the active workbook recalculation. The only way it can
know, is if the addin can insert code on-the-fly into the active workbook
(and every workbook that becomes active.)
A simple suggestion is to program an Alt-key combination that will
recalculate the active workbook and recalculate the addin.
Regards,
Antonio Elinon
"kikde" wrote:
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
|