HOW TO: How to stop an add-in function from running from inside the Excel Formula Wizard

Reference: Q0017

Article Last Modified on 23-Nov-2005

The information in this article applies to:

XLL+ for Visual Studio 6 - 3, 4.1, 4.2, 4.3.1
XLL+ for Visual Studio .NET - 3, 4.1, 4.2, 4.3.1
Excel - all versions

How to stop an add-in function from running from inside the Excel Formula Wizard

Issue

I have an add-in function that takes a long time to run. I do not want it to run from within Excel's Formula Wizard - the list of arguments is incomplete at this point, and running the function is a waste of time. How can I stop the function from running?

Answer

You can use the XLL+ Function Wizard to add code to your function for this purpose; see http://www.planatechsolutions.com/xllplus-online/start_formula_wizard2.htm to learn how.

You can also write code explicitly to prevent your function from running inside the Excel Formula Wizard; see http://www.planatechsolutions.com/xllplus-online/start_formula_wizard3.htm for instructions.