XL: Toolbar Button Image Changes Unexpectedly

ID: Q119209

5.00 5.00c 7.00 WINDOWS kbother

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, when you open a workbook that has been saved with an attached toolbar, the Currency Style button image ($) may appear on a button on the toolbar instead of the button image that appeared when you saved the workbook.

CAUSE

This behavior occurs when you copy a built-in toolbar button image to a button on a toolbar, copy the toolbar to a workbook, and then delete the toolbar from the workspace. This behavior does not occur if you paste an edited button image to a button on the custom toolbar, or if you edit the image after pasting it to the button. The button image that appears is a dollar sign (the image that appears on the Currency Style toolbar button).

This problem occurs only if there is no other toolbar with the same name as the toolbar attached to the workbook that you open.

WORKAROUND

To avoid having the button image on your custom toolbar change to the Currency Style image, do the following after you paste the button image:

1. From the View menu, choose Toolbars, and choose the Customize button.

2. From your custom toolbar, choose the button with the copied button

   image and click the right mouse button.

3. From the shortcut menu, choose Edit Button Image. In the Button Editor
   dialog box, choose OK. You do not have to make any changes to the button
   image.

4. Close the Customize dialog box.

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

"Visual Basic User's Guide," version 5.0, Chapter 12, "Attaching Toolbars to Workbooks"

For more information about Using Toolbar Buttons, choose the Search button in Help and type:

   toolbar buttons

KBCategory: kbother KBSubcategory:

Additional reference words: 5.00 5.00c 7.00 face toolface

Version           : 5.00 5.00c 7.00
Platform          : WINDOWS

Last Reviewed: September 15, 1996