How to disable Clipboard Section (Cut, Copy, Paste) under Home Tab - Excel 2007

[mohitbang]

Hi friends,

I was stuck with task for a long time, wherein I had to disable all options of Cutting, Pasting Data (Copying should be enabled) in a workbook (Excel 2007).

And with the help of Experts from VBA Express itself :clap:, I was able to crack it down partially i.e. the code disables the shortcut Keys (ctrl + X, ctrl + Y) and the cut, paste options on right click. But it is not disabling the Clipboard Section (Cut, Copy, Paste) under Home Tab and also the feature of "Fill Handle".

Please Help.!!!

Would appreciate any help.... :)

[mohitbang]

Excel Experts please help.....:bug:

[holycow]

Download and install this small application OfficeCustomUIESetup.zip at http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/07/7293.aspx

Then follow this instructions from Ron De Bruin http://www.rondebruin.nl/win/s2/win016.htm

Basically you need to

1. Ensure file is closed in Excel
2. Open it in CustomUI Editor
3. Copy and paste the first lot of blue XML code from the second link above into the section customUI.xml
4. Delete the bits you don't want

You should end up with this


<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<tabs>
<!-- Set visible to false for the Clipboard group on the Home tab-->
<tab idMso="TabHome">
<group idMso="GroupClipboard" visible="false"/>
</tab>
<!-- Point to the Built-in tab to the ribbon -->
<tab idMso="TabHome">
<!-- Add Clipboard group -->
<group id="DupClipboard" label="Clipboard" insertBeforeMso="GroupClipboard" >
<button idMso="Copy"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>

5. Save and close CustomUI Editor
6. Open file in Excel

Not sure what to do about the fill handle though.

Edit: I had an idea for fill handle but see how you go with above first.