Microsoft KB Archive/98600

{|
 * width="100%"|

Default Tool IDs for Custom Tools

 * }

-

The information in this article applies to:


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

-

SUMMARY
In Microsoft Excel, you can create custom tools. To do this, choose the Toolbars command from the Options menu, then choose the Customize button, and select the Custom category.

Custom tool faces in Microsoft Excel have the default ID numbers 200 through 231. You can use these default ID numbers when you create or modify toolbars in a macro (provided that these numbers have not been overridden by custom tool faces that you have created).

MORE INFORMATION
The following are the definitions of the default ID numbers for custom tool faces:

  #     Definition --

200  Integral 201  Cards 202  Word Icon 203  Mail Icon 204  Power Point Icon 205  Project Icon 206  Disk with Up Arrow 207  Disk with Down Arrow 208  Slash X   209   Speaker 210  Musical Note 211  Happy Face 212  Sad Face 213  Clock 214  Fish 215  Push Pin 216  Key 217  Two Columns 218  Coffee Mug 219  Speaking Balloon 220  Telephone 221  Heart 222  Diamond 223  Spade 224  Club 225  Trashcan 226  Bell 227  Calendar 228  Video camera 229  Hand 230  Envelope 231  Blank Face

You can use the GET.TOOL macro function with a type_num argument of 1 to get the ID number of any tool.

To create a toolbar that displays all custom tool faces, use the following example macro

  =ADD.TOOLBAR(&quot;Custom Tools&quot;) =FOR(&quot;x&quot;,1,32) =ADD.TOOL(&quot;Custom Tools&quot;,x,199+x) =NEXT =SHOW.TOOLBAR(&quot;Custom Tools&quot;,TRUE,4,0,0) =RETURN

where x is a counter that increments the number 199 in the ADD.TOOL function by one, 32 times, to add custom tools numbering 200-231.