Cut Copy Paste Disabled

Hi ...

I am using Excel 2013.

I wanted to stop shared file users cutting, copying, pasting data on a worksheet as this often interfered with formulas and calculations.

I found the VB code that was supposed to offer the solution and pasted into a new 'Module!' and then rest of the code into 'ThisWorkbook'.

It partially did the trick. Cut, Copy and Paste was now removed from the Right-click sub menu... but I was still able to use the 'ctrl' keys and the functions were still available on the Ribbon.

Not satisfied with this part solution I deleted the new VB module and the code thinking this would restore the original functionality of the Excel Workbook.

It hasn't, and now on all Excel workbooks I open... it seems that Cut, Copy, Paste is disabled from the "Right-Click" Sub Menu!

Can anybody advise me on how to restore this? Please! - Confession = I am a VB Novice.

RSVP
Sp00gles

CutCopyPasteDisable VB Code for Module.txtCutCopyPasteDisable VB Code for ThisWorkbook.txt

Does this help?

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Originally Posted by JOHN H. DAVIS

Does this help?

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Hi John,

Thank you for the reply... But, this is the same code I used in the 1st place!
It's not fully effective in Excel 2013.

I decided to look at my problem a different way and then deleted the macro code... But herein now lies the problem as even though I did this, the Cut, Copy, Paste fcn is still partially disabled.

Restoring Excel to previous state is now the issue I am facing?!?!

Thanks.
Sp00gles

Sometimes the simplest of tasks can be attempted in an extremely over-complicated manner.

Try this in the workbook module to effectively stop people using cut / copy / paste.

They can still initialise the cut / copy procedure, but as soon as they select a different cell to paste, the clipboard will be emptied, effectively cancelling the operation.

Please Login or Register  to view this content.

Users might be able to circumvent this by pre-selecting the destination cell, then copying from outside of the workbook, but using the same line with worksheet activate / deactivate should prevent that.

Hi Jason, Yasser...

thank you both for reply... before I got to either of them I had found a solution that cured my immediate problem.
As you both were kind enough to help me I thought to share it with you (attached)


Cheers Guys,
Sp00gles