Conditional disable cut and force paste values

[Kelvin Stott]

Hello,

I've been searching around on the forum for clues, but all I've found were codes to completely disable cut/copy/paste, etc. for the entire workbook.

I want to do the following, but only for specific worksheets where B2 = TRUE:

1. Disable cut and also drag/drop
2. Allow copy
3. Allow paste as values/formula only, to keep original comments, formatting, validation, etc. Maybe even change the normal paste command to paste as values/formula?

Please, I'd really appreciate some help with this, I'm completely stuck.

Thanks,
Kelvin