Microsoft KB Archive/89287

{|
 * width="100%"|

Excel: PRESS.TOOL Requires Three Arguments

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 4.0, 5.0
 * Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0

-

SUMMARY
Page 331 of the &quot;Function Reference,&quot; version 4.0 and the Online Help of the Macro Functions Help, incorrectly state that the third argument, DOWN, for the PRESS.TOOL function may be omitted. However, omitting this argument results in the following error message when entering the PRESS.TOOL function:

Too Few Arguments

MORE INFORMATION
The PRESS.TOOL function formats a custom tool so that it appears either normal or depressed into the screen. The PRESS.TOOL function requires three arguments: BAR_ID, POSITION, and DOWN. The third argument, DOWN, is a logical value specifying the appearance of the tool. If set to TRUE, the tool appears depressed; if set to FALSE, the tool appears normal (up). This argument can be omitted as long as a comma placeholder is included in the formula as in the following example. In this case, the DOWN argument is assumed to be a value of FALSE.

=PRESS.TOOL(&quot;CustomToolbar&quot;,8,).

Note that while not explicitly stated in the documentation, this function will only work with custom tools.