Hi Protege,

I've only been a member for two days and new to the VBA side - but I had a similair problem on some sheets that I was working on a little while ago. The only way I could get round it was to put in my script to unprotect the sheet at the beginning and then when it was finished to reprotect and simulatenously protect new sheet if you need to.

I don't know if this will help you, or I might be misunderstanding what you mean.

Take care
Amanda. Oops, another thing that gave me some odd results occasionally was if the sheet was protected but not the workbook and vice versa - could be worth a look.