How to disable Ribbon in Excel 2010

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

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

**xld** · 03-22-2012, 08:59 AM

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

**lalit.purohi** · 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..

Regards,

**Paul_Hossler** · 03-25-2012, 07:43 AM

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 tags courtesy of www.thecodenet.com

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

03-20-2012, 02:49 AM	#1
lalit.purohi VBAX Newbie Joined: Mar 2012 Posts: 2 Kb Entries: 0 Articles: 0	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
Local Time: 09:24 AM Local Date: 05-23-2013 Location:

03-22-2012, 08:59 AM	#2
xld Distinguished Lord of VBAX VBAX Expert Joined: Apr 2005 Posts: 23,118 Kb Entries: 3 Articles: 2	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
Local Time: 04:54 AM Local Date: 05-23-2013 Location:

03-24-2012, 07:25 AM	#3
lalit.purohi VBAX Newbie Joined: Mar 2012 Posts: 2 Kb Entries: 0 Articles: 0	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,
Local Time: 09:24 AM Local Date: 05-23-2013 Location: