Restrict Cut-Copy-Paste in the specific range of cells having data validation in a particular Sheet of a workbook

[vishalgupta8826]

Hello,

I want to disable Cut-Copy-Paste in the specific range of cells having data validation in a particular Sheet of a workbook.
Users should still be able to select the value from the data validation list but shouldn't be able to cut-copy-paste any or even the value part of the list into those cells.

Reason is to avoid undesirable copy-paste of conditional formatting because of the copy paste of values from one cell to other.

Let me know if there is any way to achieve this.

Thanks in advance.

 

[Chihiro]

Refer to this link. Adjust code as desired.

Cut,Copy,Paste disable

Hi I want cut,copy,Paste disable for particular range in excel sheets.Please tell me how to do this Sub ToggleCutCopyAndPaste(Allow As Boolean) 'Activate/deactivate cut, copy, paste and pastespecial menu items Call EnableMenuItem(21, Allow) ' cut Call EnableMenuItem(19, Allow) '...

chandoo.org

 

[vishalgupta8826]

Refer to this link. Adjust code as desired.

Cut,Copy,Paste disable

Hi I want cut,copy,Paste disable for particular range in excel sheets.Please tell me how to do this Sub ToggleCutCopyAndPaste(Allow As Boolean) 'Activate/deactivate cut, copy, paste and pastespecial menu items Call EnableMenuItem(21, Allow) ' cut Call EnableMenuItem(19, Allow) '...

chandoo.org

Thanks for the reply.
However, I believe macros are required to run these codes and I just noticed macros are disabled in my org.

Is there any other way to achieve the requirement?

 

[Chihiro]

There isn't unfortunately. You can't accomplish this without VBA as far as I know.

 

[vishalgupta8826]

There isn't unfortunately. You can't accomplish this without VBA as far as I know.

OKay.. Let me check with my IT/Sec team on enabling macros.