2

This is a followup question to this one: Can I make Excel beep when a calculation is finished?

The answer relies on me pressing F9.

However, even with calculations on manual, sometimes calculations happen without F9 - e.g. when I save the document.

Is there any event that I can use when a calculation happens regardless of what initiated it?

1
  • 2
    I think you would have to work this to each event (a guess). So, on the load/save/exit events and any other, you would probably need to wire up the function to fire on each event!
    – Dave
    Dec 10, 2014 at 15:28

1 Answer 1

2

Check out the Worksheet event Worksheet_Calculate or the Workbook event Workbook_SheetCalculate
It's easy for those to start firing infinite loops, though, so be careful

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .