Excel Hints

Results 1 to 4 of 4

Thread: How to disable Ribbon in Excel 2010

  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 xld's Avatar
    Joined
    Apr 2005
    Posts
    24,101
    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
    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
      To view attachments your post count must be 0 or greater. Your post count is 0 momentarily.

Posting Permissions

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