title: VBA Detail Shortcut Menu
body: <p>I am updating some old VBA code to work with Access 2010. One problem we encountered is that no Shortcut Menu appears when you right click so we create a shortcut menu and bound it to the Application object like so...</p>
  
  <pre><code>Application.ShortcutMenuBar = "GeneralClipboardMenu"
  </code></pre>
  
  <p>In general this works however if you right click on a column in a Detail pane, "Which we are using as an excel grid", no menu appears. This aspect is critical to the use of our application so we can not ignore it. </p>
  
  <p>Nowhere in the code are Shortcut Menus being disable. Also I realize shortcut menus are being replaced by the ribbon in the 2010 Office suit however right click is a basic feature that we would ideally like to keep. </p>
  
  <p>Any help would be greatly appreciated. Here is the code for creating the shortcut menu in-case it is relevant.  </p>
  
  <pre><code>Sub CreateSimpleShortcutMenu()
    On Error Resume Next 'If menu with same name exists delete
    CommandBars("GeneralClipboardMenu").Delete
    Dim cmb As CommandBar
    Set cmb = CommandBars.Add("GeneralClipboardMenu", msoBarPopup, False, False)
        With cmb
            .Controls.Add msoControlButton, 21, , , True   ' Cut
            .Controls.Add msoControlButton, 19, , , True   ' Copy
            .Controls.Add msoControlButton, 22, , , True   ' Paste
            .Controls.Add msoControlButton, 4016, , , True 'Sort Ascending
            .Controls.Add msoControlButton, 4017, , , True 'Sort Decending
        End With
    Set cmb = Nothing
  End Sub
  </code></pre>