How to cancel the calculation after the calculation started.

Add-in Express™ Support Service
That's what is more important than anything else

How to cancel the calculation after the calculation started.
 
KB LIM




Posts: 10
 Joined: 2018-01-01
Hi,

May I know how can we cancel the calculation after the calculation of worksheet started programmatically.

Thanks!
Posted 28 Sep, 2020 21:45:29 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Hello,

There's a property called CalculationInterruptKey; see https://docs.microsoft.com/en-us/office/vba/api/excel.application.calculationinterruptkey. It suggests sending such a key to the application window. I've never tried doing this.

Did you consider your functions returning an error instead?


Andrei Smolin
Add-in Express Team Leader
Posted 29 Sep, 2020 03:42:34 Top
KB LIM




Posts: 10
 Joined: 2018-01-01
Hi Andrei,

Let me try and see it is workable or not.

Thanks!
Posted 30 Sep, 2020 22:07:46 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Sure.


Andrei Smolin
Add-in Express Team Leader
Posted 01 Oct, 2020 02:28:02 Top