Copy / Cut / Patse functionality

[max8719]

Hi Guys,

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.

 

[RedBeard]

You can use Application.OnKey to disable (or repurpose) the key combinations (e.g. Ctrl+X, Ctrl+V, Shift+Del, Shift+Insert ) that you don't want used. Typically you would do this in Workbook_Open and reverse it in Workbook_BeforeClose (and you need to save the workbook if necessary within Workbook_BeforeClose to prevent the user from cancelling the Save Changes message after your code has done its work).

 

[max8719]

I am a bit of an ametur when it comes to vba. Is there a code i can copy into the sheets?