I have an Excel column where some cells are locked and others unlocked.

Say my column is B, then B1 to B4 are unlocked, B5 is locked and B6 to B7 is unlocked.

I am copying data from another sheet but want to allow pasting into the complete column and skip over B5.

Extension: If we can show to user that B5 was skipped since it is protected.

Is there a way we can do so?

Thanks!