The Features Tab contains two groups of controls:
The Behavior panel contains a list of switches which control the code that is generated for the function. The more commonly used switches are described below.
If this item is checked, then the function's result will be stored in an application-level cache. Each time the function is called, the cache is searched for an identical set of inputs. If they are found, then the result is returned from the cache and the implementation function is not called. This can result in a considerable performance improvement.
See also the Function.CacheResults property.
If this item is checked, then an additional add-in function will be created which runs the core function asynchronously, in a worker thread. The function will be have the same name as the core function, plus the suffix "Async". See Asynchronous functions in the User Guide.
See also the Function.CreateAsyncVersion property.
If this item is checked, then the function will return
#VALUE!
when it is called from the Excel Formula Wizard.
See also Excel Formula Wizard: Automating the code in the User Guide.
If this item is checked, then the function will be registered as a thread-safe function, which means that Excel can call the function on multiple threads simultaneously. See Ensuring global data is thread-safe in the User Guide.
Note that this property is ignored in Excel 2003 and below.
See also the Function.IsThreadSafe property.
If this item is checked, then the function will be registered as a volatile function, which means that Excel will recalculate any cell containing the function whenever any cell in the same sheet is recalculated. See Volatile functions in the User Guide.
See also the Function.IsVolatile property.
This group of controls specifies when and where the add-in function will be available.
Worksheet | Function can be called from worksheet cells, and will be listed in the Excel Formula Wizard. |
Macro | Function can be called from macros or as a command. It may not be called from worksheet cells. It will not be listed in the Excel Formula Wizard. |
Hidden | Function can be called from worksheets cells or from macros or as a command. It will not be listed in the Excel Formula Wizard. |
See also the Function.Availability property.