Results 1 to 4 of 4

Thread: How to disable Ribbon in Excel 2010

  1. #1

    How to disable Ribbon in Excel 2010


    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
    Apr 2005
    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..


  4. #4
    VBAX Wizard
    Apr 2007
    You can hide the Clipboard group by using XLM and the CustomUI

    <customUI xmlns="">

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


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


    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