VBA Which allows paste but not cut or copy

[max8719]

Hi Excelers,

I have found numerous VBA codes that disables cut/copy and paste functions in an excel workbook, but what I need is the ability to paste and the disability to cut or copy.

Additionally


If I can deactivate the "prt scrn" functionality that would be a nice bonus.

Thanks in advance for your feedback.

 

[oldbrewer]

to clarify, if you cannot copy or cut, what are you pasting ?

 

[max8719]

The initial plan was to copy from another document and paste into this one, however I have now combined the documents into one workbook, which has led me to the following question.

Can copy and cut be disabled in all but 1 work sheet? and leave the capability of pasting in the workbook?

Thanks in advance for any feedback