disable copy/cut/paste/paste special in excel 2010

Hello all,

i know this problem has been posted before, but I didn't find a solution for excel 2010 or 2013.

I have a worksheet in which i want the user to be able to insert/write information only, i want him to be unable to cut/copy/paste/paste special, in order to protect my formulas in the other sheets

I found a code here http://www.vbaexpress.com/kb/getarticle.php?kb_id=373 , but it seems to work only for shortcut keys, it doesn't disable the buttons on the excel clipboard menu.

Macros are enabled

can u please help me with a solution?

Thank you in advance.

Hi Alina,

Put the below code in the respective sheet event - in which you have to disable the user to copy or paste.

Please Login or Register  to view this content.

Regards,
lokicl

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

i tried it but it doesn't work, the buttons cut/copy/paste in the clipboard are still functional.

and if i copy something from another file also paste special is functional, and it shouldn't be.

I forgot to mention i am using excel 2010.

Hi Alina,

Then paste the below code in the ThisWorkbook event

Please Login or Register  to view this content.

It doesn't allow the user to copy paste until the workbook is closed.

Regards,
lokicl

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Originally Posted by Winon

Hello Alina Lorendana,

Please see if the sample Workbook in the thread below, does what you want.

http://www.excelforum.com/excel-gene...-new-post.html

Regards.

Thank you so much. It works!!

One problem, though: it does what it's suposed to do, but it seems to lack a certain code to disable this after i close the workbook, because when i open another random excel on my pc the cut/copy/paste options from right click are disabled.

can u figure out what i'm not doing right?