Excel: ENABLE.TOOL() Requires All Three Arguments

 Last reviewed: November 30, 1994
Article ID: Q89208
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY

Page 131 of the "Microsoft Excel Function Reference," version 4.0 and the Online Help of the Macro Functions Help, incorrectly indicate that the third argument, "enable," in the ENABLE.TOOL() function may be omitted. However, omitting this argument results in the following error message: 

   Too Few Arguments

MORE INFORMATION

The ENABLE.TOOL() function enables or disables a tool on a toolbar. The function requires three arguments: BAR_ID, POSITION, and ENABLE. If ENABLE is set to TRUE, the specified tool is accessible by the user; if set to FALSE, the tool may still be visible but cannot be accessed.

The ENABLE argument can be omitted as long as a comma placeholder is included in the formula. For example:

=ENABLE.TOOL("Standard",4,)

In this case, the ENABLE argument is assumed to be a value of FALSE.

REFERENCES

"Online Help," version 5.0, ENABLE.TOOL "Function Reference," version 4.0, page 131

KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 4.0 4.00 5.0 5.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.