MXL5: Type 1 Error or Hang Copying Custom Toolbar to Workbook

ID: Q128003


The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a


SYMPTOMS

In Microsoft Excel, when you copy a custom toolbar to your workbook, one of the following symptoms may occur:

  • The Microsoft Excel application hangs


  • -or-

  • Microsoft Excel closes and you receive a Type 1 error


  • -or-

  • You receive the following error message:
    Not enough memory to display completely



CAUSE

This behavior occurs if you copy a button image from one button, and paste the button image to a button on the custom toolbar, and you then copy the custom toolbar to a workbook. This behavior occurs even if you close Microsoft Excel after you paste the button image and before you copy the toolbar to your workbook.

Note that this problem does not occur when you copy a picture other than a button image, and paste the picture as a button image to a button on your custom toolbar.


WORKAROUND

To work around this problem, do the following before you copy the toolbar to your workbook:

  1. After you paste the button image to your toolbar button, hold down the CONTROL key, and click the button to which you just pasted the image.


  2. From the Button shortcut menu, choose Edit Button Image.


  3. In the Button Editor dialog box, choose OK.


  4. Close the Customize dialog box.


You can now copy the toolbar to your workbook without receiving any error messages.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


REFERENCES

For more information about the Attach Toolbars Command (Tools menu), choose the Search button in Help and type:

toolbars

Additional query words: 5.00a

Keywords : xlmac
Version : MACINTOSH:5.0,5.0a
Platform : MACINTOSH
Issue type :


Last Reviewed: September 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.