Hello experts,


I want to avoid that my users delete certain rows, because they contain
hidden information.
When they delete these rows the functionality will be disturbed.

They are allowed to make others changes in the cells of these rows, just not
to delete the whole row.

I try to find a way to detect this with VBA code and then show a message.
Did some examinations on the Worksheet.Change event, but still have no clue.
It would be good already if it was possible to detect that one or several of
the "forbidden" rows are selected (as whole rows) before deleting them.

Hope you can help, it is very important for me.


Thanks in advance,

Ed van Wijngaarden