Function attribute: nopreview

The nopreview attribute controls whether a function is calculated from the Excel Formula Wizard. If the flag is set to true, then the following code will be emitted in the function header:

    if (CXllApp::IsInFormulaWizard())
        return CXlOper::RetError(xlerrNA);

or:

    if (CXllApp::IsInFormulaWizard())
        return 0;

You can control the value of the attribute with the Disabled in Excel Formula Wizard command on the Function menu of the XLL+ AppWizard. This item also appears on the drop-down menu of the Edit Function Attributes tool-button.

You can also edit the value for the current function in the Edit Function Attributes window. The window can also be used to set the default value of the attribute, which will be applied to all new functions.

See Also

Function Wizard | Disabled in Excel Formula Wizard command | CXllApp::IsInFormulaWizard method