Microsoft KB Archive/85080

= Microsoft Knowledge Base =

Excel: Custom TOOL_ID Numbers Range from 200 to 231
Last reviewed: April 16, 1996

Article ID: Q85080

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
The text for the ADD.TOOL function in the &quot;Microsoft Excel Function Reference,&quot; version 4.0 incorrectly states that in order to specify a custom tool, use &quot;a number greater than 140&quot; as a custom TOOL_ID number. In actuality, custom tools are numbered from 200 to 231.

The sample illustration on page 11 shows a TOOL_REF table listing two custom tools numbered 143 and 145. This table will create a macro error if used by ADD.TOOL within Microsoft Excel.

MORE INFORMATION
Custom TOOL_ID numbers can be used in command macros to add custom tools to toolbars. The numbers can be entered either as part of an array in the ADD.TOOL function or as part of a tool reference area on the macro sheet. Built-in tools are numbered from 1 to 140. The use of numbers between 141 and 199 generates a macro error when the ADD.TOOL function is executed.