Disable cutcopy for unlocked cell

[Pobek]

Hi, I have an unlocked cell that I want users to manually input parameters BUT not to be able to cutcopy from anywhere (and most certainly NOT from other non excel formats that they may have kept a record of said parameter)

Any ideas? I gather private function should do this but Ive been lead to believe it wont work for cutcopy from external sources such as outlook ...

 

[Vbagreenhorn1]

https://www.extendoffice.com/documents/excel/4289-excel-disable-cut-copy-paste.html

 

[Pobek]

Apologies, I did not clarify. I need the disable ONLY for that particular cell. Not the entire workbook as I am reading on your link.

 

[Vbagreenhorn1]

Put the code in a worksheet_selectionChange event and use:

if target.address = Your cell then
code to disable
else
the opposit
end if