Excel: PRESS.TOOL() Requires Three ArgumentsID: Q89287
|
Page 331 of the "Function Reference," 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
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("CustomToolbar",8,).
Note that while not explicitly stated in the documentation, this function
will only work with custom tools.
"Online Help," version 5.0, PRESS.TOOL
"Function Reference," version 4.0, page 331
Additional query words: 5.0 halt
Keywords :
Version :
Platform :
Issue type :
Last Reviewed: March 26, 1999