Microsoft KB Archive/89208

{|
 * width="100%"|

Excel: ENABLE.TOOL Requires All Three Arguments

 * }

-

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 &quot;Microsoft Excel Function Reference,&quot; version 4.0 and the Online Help of the Macro Functions Help, incorrectly indicate that the third argument, &quot;enable,&quot; 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(&quot;Standard&quot;,4,)

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