MXL5: Wristwatch Mouse Cursor in Button Editor Using Macro

ID: Q128712

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SYMPTOMS

In Microsoft Excel, when you display the Button Editor dialog box by using a Visual Basic for Applications procedure or a Microsoft Excel version 4.0 macro, the pointer may be displayed as a wristwatch instead of as an arrow.

CAUSE

This behavior occurs when you use a macro to display the Button Editor dialog box. For example, when you run a Visual Basic for Applications procedure that contains the following command


   Application.Toolbars(1).ToolbarButtons(1).Edit

or an Excel 4.0 macro that contains the following function


   =Edit.Tool(1,1)

the Button Editor dialog box appears, but the pointer is a wristwatch instead of an arrow.

Note that even though the mouse pointer is a wristwatch, you can still use the pointer to edit the button image, choose OK, and so on. The pointer behaves as if it is an arrow, even though it is a wristwatch.

This behavior does not occur if you display the Button Editor dialog box by choosing Edit Button Image from the toolbar button shortcut menu.

WORKAROUND

To work around this problem, use any of the following methods.

Method 1

Use the cursor to edit the button image as needed even though it is a wristwatch instead of the arrow. Click OK or press RETURN when you have finished editing the button.

Method 2

Open the Button Editor dialog box from the toolbar button shortcut menu by following these steps:

On the View menu, click Toolbars.

Click Customize.

Hold down CONTROL, and then click the toolbar button that you want to edit.

On the toolbar button shortcut menu, click Edit Button Image.

The Button Editor dialog box appears, and the mouse cursor is an arrow as expected.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about ToolbarButton object methods, click the Search button in Help and type:

toolbarButton object

Additional query words: 5.00a

Keywords : kbprg kbdta xlmac
Version : MACINTOSH:5.0,5.0a
Platform : MACINTOSH
Issue type : kbbug