Disable cut and paste for protected cells

**Lyndon** · 08-24-2007, 09:40 AM

Afternoon all,

Currently I have a spreadsheet that different sites report back to me on.
These spreadsheets have had the tabs protected with some cells protected and some cells not, as I wish them to enter certain information.

Currently the unprotected cells are able to be cut and pasted over other unprotected cells, how can I disable the user from being able to cut and paste in the entire workbook.

Regards,
Lyndon

**JR@SGC** · 08-24-2007, 09:58 AM

Hi,

As far as i can remember this should disable all the options e.g menus as well as right click options and shortcut keys.

Please Login or Register  to view this content.

just place in the 'This workbook' module and not standard module in VBA editor (Alt-F11)

hope it helps

**Greg M** · 08-24-2007, 10:25 AM

Hi there,

As a general rule, Pasting doesn't create as many problems as Cutting, because the cell locking prevents values from being pasted where they shouldn't be. Cutting is a different story altogether, as it can corrupt cell references in formulas etc.

Some time ago I wrote the following code which totally disables the Cut operation for the workbook which contains the code. Other workbooks are unaffected.

You might find the following code useful. It must be inserted in the "ThisWorkbook" VBA code module of the workbook which you want to protect.

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

**Lyndon** · 08-24-2007, 10:35 AM

Thank you for the help.

Greg, you have hit the nail on the head that is my exact problem it is throwing out my linked sheet irrespective of how I reference the formulas between tabs.

1st time I have ever submitted a post on a forum and I greatly appreciate the feedback.

**Greg M** · 08-24-2007, 10:51 AM

Hi again Lyndon,

Thanks for the feedback. You're very welcome - glad to have helped.

All the best,

Greg M

**Lyndon** · 08-24-2007, 10:57 AM

Greg,

Should this disable the right click mouse cut and paste short cut.

Currently the menu items are disabled with a message, but I have circumnavigated it by usint he mouse.

Any ideas.

Lyndon.

**Greg M** · 09-08-2007, 07:15 AM

Hi again Lyndon,

Sorry for the delay in getting back to you with this one.

To disable the "Cut" command on the "Cell" shortcut (right-click) menu, use the following code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Best regards,

Greg M

**Jithesh** · 07-17-2012, 07:57 AM

Greg - Need help to disable this function for selective cells in a worksheet.

**arlu1201** · 07-17-2012, 08:41 AM

Jithesh,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.