How to stop Sheet change event affecting all other cells by unprotecting the sheet

[bdouglas1011]

I have a sheet that I run a change event for the range (B10:B47) and when I change a cell in that range the code works fine it will unprotect the sheet runs it code and re-protects the sheet.

my problem is that the whole sheet is password protected and if I change any other cell on the page the sheet unprotects itself and I can not get to reprotect.

Please Login or Register  to view this content.

any thoughts??

[Fluff13]

How about

Please Login or Register  to view this content.