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

ID: Q128003

5.00 5.00a MACINTOSH kbtool xlmac

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.

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 reference words: 5.00 5.00a

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

Last Reviewed: November 17, 1997