Default Tool IDs for Custom Tools

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.00a 5.00c

Keywords : kbmacro kbui
Version : WINDOWS:4.0,5.0; MACINTOSH:4.0,5.0
Platform : MACINTOSH WINDOWS
Issue type :