How to disable Ribbon in Excel 2010

Printable View

03-20-2012, 02:49 AM
lalit.purohi

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
03-22-2012, 08:59 AM
Bob Phillips

Even if you disable them, Ctrl-C etc will still work.
03-24-2012, 07:25 AM
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,
03-25-2012, 07:43 AM
Paul_Hossler

1 Attachment(s)

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