Consulting

Results 1 to 4 of 4

Thread: How to disable Ribbon in Excel 2010

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    How to disable Ribbon in Excel 2010

    Hi,

    Being my first post, hoping for a sound advices from thinking minds on this forum,

    I am looking for va code to disable a part of ribbon on excel 2010. for eg : Of the whole ribbon in Excel 2010, on the Cut, Copy, Paste buttons needs to be disabled.

    Please do advise with thoughts and suggestions on the same

    Thanks in Advance

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    Even if you disable them, Ctrl-C etc will still work.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Hi, i wrote a code where the functions like ctrl+c, ctrl+x,etc gets disabled.. there was only one problem of making the ribbon disable.... looking for some suggestions and help..

    Regards,

  4. #4
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    You can hide the Clipboard group by using XLM and the CustomUI

    [vba]
    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
    <ribbon>
    <tabs>

    <tab idMso="TabHome">
    <group idMso="GroupClipboard" visible="false"/>
    </tab>

    </tabs>
    </ribbon>
    </customUI>
    [/vba]

    but that only works in the individual XLSM unless you make an add in

    Paul


    Admin edit: The file contains this specified XML code and will hide that portion of the ribbon. Your ribbon state will be returned when you close the file (only for xl2007 onward).
    Attached Files Attached Files

Posting Permissions

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