Sorry the sheet somehow became protected!!!!!!!!!!

EM

"ExcelMonkey" wrote:

I have a line of code which all of sudden stopped working. Can't figure out
why. I am getting an error message saying "Run Time Error 1004. Unable to
set Color Index Property of the Interior Class." I swear it was working ten
minutes ago.

In the immediate window I get:
?sh.Cells.Interior.ColorIndex
-4142

For Each sh In ActiveWorkbook.Worksheets
sh.Cells.Interior.ColorIndex = xlNone
sh.Cells.FormatConditions.Delete
Next sh