Consulting

Results 1 to 2 of 2

Thread: Excel 2007 Disable right click menu items

  1. #1

    Excel 2007 Disable right click menu items

    Hello,

    I was wondering how can someone disable right click menu items in EXCEL 2007.

    Specifically, I would like to disable the 'Format Shapes' item from all right click menus for any types of shapes.

    thanks

    crosspost: http://www.mrexcel.com/forum/showthr...ght=click+2007

  2. #2
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    In the CustomUI, I think you need to set the idMso you want to false.

    These are from a sample in the CustomUI editor


    <!-- Disable Save As in the Office button menu and also the splitbutton menu-->
    <
    command idMso="FileSaveAs" enabled = "false" />
    <
    command idMso="FileSaveAsMenu" enabled = "false" />
    <!--
    Example to disable the MergeCenterMenu on the Home tab in the Alignment group-->
    <
    command idMso="MergeCenterMenu" enabled = "false" />


    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •