View Full Version : How to disable Ribbon in Excel 2010

03-20-2012, 02:49 AM

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

Bob Phillips
03-22-2012, 08:59 AM
Even if you disable them, Ctrl-C etc will still work.

03-24-2012, 07:25 AM
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..


03-25-2012, 07:43 AM
You can hide the Clipboard group by using XLM and the CustomUI

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

<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).