Excel: Custom Tool Faces Must Be Picture-Type Objects

Last reviewed: November 29, 1994
Article ID: Q86457

The information in this article applies to:

  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

SUMMARY

Page 11 of the "Microsoft Excel Function Reference," version 4.0, shows a sample tool reference area (used by the ADD.TOOL() function), which incorrectly lists Rectangle 1 and Rectangle 3 as custom tool faces. Since tool faces must be picture objects, Microsoft Excel graphics are not acceptable. The default face for the tool will be used instead of the graphic listed in the reference area.

MORE INFORMATION

Custom tool, faces must be picture objects. Other graphical objects (rectangles, ovals, lines, arcs, and drawings) must be converted to picture objects before they can be used as tool faces.

To convert an Excel drawing object to a picture object:

  1. Select the rectangle, circle, line, arc or drawing to convert.

  2. From the Edit menu, choose Copy.

  3. From the Edit menu, choose Paste Special.

  4. Select Picture (Windows) or PICT (Macintosh) in the Data Type field and choose the OK button.

Note: Pictures can also be created with the camera tool or pasted via the Clipboard.

REFERENCES

"Function Reference," version 4.0, pages 11-12


KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 4.00 buttons toolbars bar


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: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.