detect any (entire) row selection in entire sheet and unprotect?

Originally Posted by niceguy21

hello!


Looking for the following code:

sheet is currently locked (enabled for locked cell selection).

VBA detects if any whole row(s) say 21, 22 are selected and automatically unprotects sheet.

THEN:

if these exact rows are deleted.. sheet automatically protects again.

If the user deselects these rows.. sheet protects again.

(this is design to perform specific row deletion)

[/CODE]

Your thoughts,

Thanks!

Please Login or Register  to view this content.

something like this?