HOW TO: How to stop an add-in function from running from inside the Excel Formula Wizard
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
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?
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.