How to disable Ribbon in Excel 2010

[lalit.purohi]

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

[Bob Phillips]

Even if you disable them, Ctrl-C etc will still work.

[lalit.purohi]

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,

[Paul_Hossler]

You can hide the Clipboard group by using XLM and the CustomUI


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

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

</tabs>
</ribbon>
</customUI>


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