MXL5: Wristwatch Mouse Cursor in Button Editor Using Macro

• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel 98 Macintosh Edition

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

   =Edit.Tool(1,1)

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.

WORKAROUNDS

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

Method 1

Use the cursor to edit the button image as desired 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:

1. On the View menu, click Toolbars.

2. Click Customize.

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

4. On the Toolbar Button shortcut menu, click Edit Button Image.

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 ToolbarButton object methods, choose the Search button in Help and type:

    toolbarButton object