XL98: How to Disable Shortcut Menus

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.