Execute macro before Recalculation

    Execute macro before Recalculation

    Hello everyone,

    I am looking since quite a long time for a way to execute a macro, when clicking the "Refresh Button" in Report manager.The macro has to be executed before the recalculation occurs. Is this feasible?

    So far, I am only launching my macro, when opening the report with function_open.

    PHP Source Code

    1. function __open()
    2. {
    3. ActiveSheet()->Range('D4') -> value = 0;
    4. }

    Let me know if this is not clear.

    Thanks for your help and have a nice day.