VBA to disable cut option

[Keibri]

Hi all,

If possible, is there any VBA which could be used to disable the 'cut and paste' option (thus one would not be able to use the cut option in any way, i.e. 'right click', 'drag and drop', 'ctrl+x')?

If possible the copy function would still be enabled.

If not possible to enable 'copy' whilst disabling 'cut', would be great if the code would disable both 'copy and cut' +'drag andd drop', 'right click' and 'ctrl+x'.

Appreciate a lot your kind help!

Thanks a lot!

Keibri

[J.Green]

Will this work for you ?

http://www.asap-utilities.com/excel-...tegorie=9&m=85

[Winon]

Hello Keibri,

You may want to start with the Code below, placed in the attached sample Workbook for your consideration.

Please Login or Register  to view this content.

For Code in say Sheets1 to 3:

Please Login or Register  to view this content.

In a Standard Module:

Please Login or Register  to view this content.

Regards.

[Keibri]

Woww!! that's some great VBA and amazing help!! thanks a lot, you solved it out brilliantly!

really appreciate it!! Exactly what I was looking for!!!! Thanks a bunch!

I am sorry if I bother one last thing, would it also be possible to have the same thing but only allow for 'ctrl+c' maybe? If not possible, it's already great as is! Apologies for my lack of VBA knowledge!

Thanks

keibri

[Winon]

Hello Hello Keibri,

Thank you for the feedback, and marking the Thread as Solved. Also thank you for the "Rep.", Much Appreciated!

would it also be possible to have the same thing but only allow for 'ctrl+c' maybe?

Please replace that Sub in Module 1 with the Code below:

Please Login or Register  to view this content.

Regards.