Protected Sheet

[Dazzawm]

I keep getting message that I can't find/replace because its a protected sheet. Is there a setting I can change to turn this off?

 

[RoryA]

Either unprotect the sheet, or don't do a find/replace on that sheet.

 

[Dazzawm]

Either unprotect the sheet, or don't do a find/replace on that sheet.

I don't see that it is protected, and I need to do a find/replace!

 

[RoryA]

Are you doing the Find/Replace to the entire workbook, or just a specific sheet?

 

[Dazzawm]

Are you doing the Find/Replace to the entire workbook, or just a specific sheet?

Sheet

 

[RoryA]

Well then assuming you don't have more than one sheet selected, I'd have to assume that the sheet is in fact protected. If you do have more than one selected, it will actually operate on all of them.