VBA Disbale Copy&Paste in target range (not complete sheet/workbook)

[RobGER]

Hello everyone

I am quite new to VBA and this forum and hope somebody of You can help me.

I am preparing an Excel Sheet which is clustered in an input area, required editable variables (cells with data validations) and an output area (formulas). To protect my formulas and variables, I locked a great portion of the sheet via the intrinsic cell protection. However, I have cells with drop-down menus und editable variables which I can not lock. As far as I know, the only way to protect a cell with data validation ist to disable copy&paste fuction. I searche din lots of forums but could only find quite old code which seems to not work at all. The major problem is that I want to enable these functions only in a specific target area and not the whole sheet/workbook.

I am thinking of a combination of these 3 code blocks to get this problem solved, however my skills are that minor, that I can't figure it out by myself.

Please Login or Register  to view this content.

AND

Please Login or Register  to view this content.

AND this 3. code which undos changes to certain target ranges. It works fine but doesn't inhipit copy and past.

Please Login or Register  to view this content.

Thank you very much in advance for your help.

Best regards
RobGER

[RobGER]

In the meanwhile I solved this Problem on my own. In case anyone is interested, find the code below:

Please Login or Register  to view this content.

Cheers,
RobGER

[RobGER]

I further updated the code to protect cells in the worksheet by clearance in a better manner. Some cells are protected by data validation, so far cannot be cleared by "backspace" but still when pressing "Delete".

Please Login or Register  to view this content.

Cheers,
RobGER