Microsoft KB Archive/184895

= XL98: How to Disable Shortcut Menus =

Article ID: 184895

Article Last Modified on 6/17/2005

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184895





SUMMARY
There are many shortcut menus in Microsoft Excel 98 Macintosh Edition that appear when you hold the CONTROL key and click an object. For example, if you hold the CONTROL key and click a worksheet tab, the following shortcut menu appears:

Insert...

Delete

Rename

Move or Copy...

Select All Sheets

-

View Code

This article lists all of the built-in shortcut menus in Microsoft Excel 98 Macintosh Edition and provides a sample Visual Basic for Applications macro that disables a shortcut menu.



MORE INFORMATION
The following table lists all of the built-in shortcut menus and the Index property value for each menu.

  Shortcut menu                 Index property Query and Pivot                     18 Shapes                              24 Inactive Chart                      25 Excel Control                       26 Curve                               27 Curve Node                          28 Curve Segment                       29 Pictures                            30 OLE Object                          31 ActiveX Control                     32 WordArt                             33 Rotate Mode                         34 Connector                           35 Workbook tabs                       36 Cell                                37 Column                              38 Row                                 39 Cell                                40 Column                              41 Row                                 42 Ply                                 43 XLM Cell                            44 Document                            45 Desktop                             46 Nondefault Drag and Drop            47 AutoFill                            48 Button                              49 Dialog                              50 Series                              51 Plot Area                           52 Floor and Walls                     53 Trendline                           54 Chart                               55 Formula Bar                         56 PivotTable                          57 Query                               58 Query Layout                        59 AutoCalculate                       60 Object/Plot                         61 Title Bar (Charting)                62 Layout                              63 Built-in Menus                      83 Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. The following sample Visual Basic macro disables the shortcut menu for worksheet tabs: Sub Disable_Shortcut CommandBars(43).Enabled = False ' You can also use the name of the shortcut menu like this ' line of code: CommandBars("ply").Enabled = False End Sub NOTE: To enable the shortcut menu for worksheet tabs, modify the macro, change the value of the Enabled property to True, and then rerun the macro.

