Disable Copy and Paste from Clipboard Buttons

**Durobell** · 08-07-2012, 07:37 AM

I am looking for a way to prevent all copying and pasting in a workbook and potentially just a worksheet if possible.

I can't use protection as the main area I want to prevent the copy and paste is with data validation drop down boxes with conditional formatting, so the user needs to be able to select them to use the drop down.

I don't want the user to be able to copy and paste them as the pasting of the conditional formatting seems to duplicate the formatting which complicates the formatting and eventually bogs things down (worksheet has over a thousand of these cells).

I have seen quite a few solutions that prevent Cntrl C and V type copy and paste but nothing seems to prevent the use of the copy and paste buttons on the menu ribbon

Is it possible to prevent copy and paste from all sources ?

Cheers

**john55** · 08-07-2012, 08:10 AM

Andy has a very good solution, see if it helps you
http://www.excelforum.com/excel-prog...bon-excel.html

**Durobell** · 08-07-2012, 09:41 AM

Thanks John

This seems to work great for the whole workbook although it doesn't disable the "disable" when you close the book, so once you have run it all excel workbooks have this functionality disabled.

What code should I add to make it revert to full functionality when the workbook is closed ?

Also I assume seeing as it effects the ribbon it can only work at a workbook level and cannot be modified to work only on a specific worksheet ?

Cheers

**royUK** · 08-08-2012, 01:40 PM

In the specific sheet

Please Login or Register  to view this content.

In a Standard module

Please Login or Register  to view this content.

**Durobell** · 08-09-2012, 05:58 AM

Hi Roy

Thanks but this code doesn't disable the copy and paste buttons on the ribbon like the original code does

Cheers

Duane

**royUK** · 08-09-2012, 07:39 AM

The best that you could do with the Ribbon for individual sheets is hide it. To change the ribbon requires xml & I think will only apply to the whole workbook

**Durobell** · 08-09-2012, 08:09 AM

Thanks Roy

When you say hide the ribbon can you hide a specific part of the ribbon i.e the clipboard section with the copy and paste buttons ?

I couldn't hide the whole ribbon but if I can do just that part of the ribbon that would work for me

Cheers