XL98: Drawing Objects Behave Differently When Clicked

Last reviewed: March 11, 1998
Article ID: Q182298
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, if you press the OPTION key, and then click a drawing object, a Visual Basic for Applications macro that is assigned to the drawing object does not run. Instead, the drawing object is selected.

CAUSE

Clicking a drawing object or an AutoShape behaves differently in Microsoft Excel 98 Macintosh Edition than it does in earlier versions of Microsoft Excel.

STATUS

This behavior is by design of Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

Assigning a Macro

In Microsoft Excel, you can assign a macro to a drawing object or an AutoShape. When you click the drawing object or AutoShape, the assigned macro runs. To assign a macro to a drawing object, follow these steps:

  1. Hold down CONTROL and click the drawing object. On the shortcut menu, click Assign Macro.

  2. In the Assign Macro dialog box, click a macro in the list of macros.

        -or-
    

    Type the name of the macro in the Macro Name/Reference box, and then click OK.

Clicking a Drawing Object

After you assign a macro to a drawing object or an AutoShape, you can run the macro by clicking the object. If no macro is assigned to the drawing object, clicking the drawing object selects it.

CONTROL-Clicking a Drawing Object

If you hold down CONTROL and click a drawing object or an AutoShape, a shortcut menu appears. The shortcut menu contains menu commands that pertain to the drawing object. If you then press ESC, the drawing object remains selected. If a macro is assigned to the drawing object, it does not run.

Pressing OPTION

In earlier versions of Microsoft Excel, you can run the macro that is assigned to a drawing object by pressing the OPTION key and clicking the drawing object. In Microsoft Excel 98 Macintosh Edition, doing this selects the drawing object but does not run the macro.

Pressing CONTROL

In all versions of Microsoft Excel, you can select a drawing object or an AutoShape by pressing CONTROL and clicking the drawing object.

Pressing SHIFT

In all versions of Microsoft Excel, if no macro is assigned to a drawing object, you can select it by pressing SHIFT and clicking the drawing object. If a macro is assigned to the drawing object, pressing SHIFT while clicking the drawing object runs the macro.


Additional query words: XL98
Keywords : kbprg kbdta kbnewfeature xlvbainfo xl97vbmigrate xldraw
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 11, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.