Default Tool IDs for Custom Tools

 Last reviewed: February 2, 1998
Article ID: Q98600
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("Custom Tools")
   =FOR("x",1,32)
   =ADD.TOOL("Custom Tools",x,199+x)
   =NEXT()
   =SHOW.TOOLBAR("Custom Tools",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.

REFERENCES

"Users Guide 2", version 4.0, pages 154-182 "Function Reference", version 4.0, page 206

Additional query words: 4.00 4.00a 5.00 5.00c
Keywords : kbmacro kbui kbfasttip
Version : WINDOWS:4.0,5.0; MACINTOSH:4.0,5.0
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.