detecting copy paste of shapes in sheet or shape deletion

[bagullo]

Hi,

I have an excel tool that generates a schedule based on a data sheet
users can move milestones and information is updated automatically on the sheet

however, I want to prevent users from doing copy-paste with existing shapes, or deleting them by clickling del key while selecting them

is there any reliable and efficient way to do that?

to update dates on the data sheet I have a macro that runs every 2 secons and checks milestone positions
at best would be some slight modification to the macro to at least show a warning that something "illegal" has been done and that user must refresh schedule render from data again.

since shapes have already a custom-name, when copy-pasting, name remains the same.
I could try to detect two shapes with the same name, but I do not come up with an efficient way to do that that can be called every two seconds without freezing everything up.

all feedback welcome!

[bagullo]

Actually I just came with a solution
I can protect the sheet, and unprotect it only when the macro is running with a timer

ShapeAddedDeletedDetection.xlsm

any other approach?