Is it possible to stop execution of UDF's ?

saurav

unread,

Sep 6, 2011, 1:29:54 AM9/6/11

to Excel-DNA

Hi All,

Is it possible to stop execution (programmatically) of the UDF's
created by Excel-DNA when Excel's Calculation is fired or when user
simply enters a formula and presses [enter], so that the formula is
displayed and not the executed value?

Thanks, Saurav

Govert van Drimmelen

unread,

Sep 7, 2011, 6:23:49 PM9/7/11

to Excel-DNA

Hi Saurav,

There is a way to check whether the user has pressed escape during
your calculation or macro - you'd need to check in the Excel SDK for
details - XlCall.xlAbort might be the test.

A user can toggle between the formulae and the calculated result on a
sheet by pressing Ctrl+` (that's the back-tick key).

Regards,
Govert

Arjun Shetty

unread,

Jul 26, 2013, 4:58:43 AM7/26/13

to exce...@googlegroups.com

Hi Saurav,

I am trying to find a way to stop execution of the UDF's
created by Excel-DNA when Excel's Calculation is fired .

Would like to know if you were able to achieve this.

Please do let me know in case of any ideas/suggestions.

Regards,

Arjun

Reply all

Reply to author

Forward