no im afraid it still does the same thing, it clears contents in column C when column A is blank in the same row (which is what I want).
But it only does this once I click unprotect sheet (now clicking unprotect sheet i dont require a password), I then click any cell on the same sheet this then clears it, but it does nothing unless I do this.
What i would really like to do is clear this without clicking unprotect sheet and selecting any cell in the sheet. Also would prefer it to password protect the sheet when it locks the sheet again so only i can unlock the sheet.


regards,

Andrew