Change cell format based on its color

[Anders]

Dear Experts

Being new to VBA I have following question.
In an Excel 2003 workbook, where all cells as default are protected, I
would like to unprotect cells with a specific color.
Can any of you give a clue?

Thanks in advance
Anders
Copenhagen

[Tom Ogilvy]

Is the color produce by conditional formatting?

If not

assuming the sheet is unprotected.

For each cell in activesheet.UsedRange
if cell.interior.ColorIndex = 5
cell.Locked = False
end if
Next

--
Regards,
Tom Ogilvy

"Anders" <[email protected]> wrote in message
news:[email protected]...
> Dear Experts
>
> Being new to VBA I have following question.
> In an Excel 2003 workbook, where all cells as default are protected, I
> would like to unprotect cells with a specific color.
> Can any of you give a clue?
>
> Thanks in advance
> Anders
> Copenhagen
>

[Anders]

Is it really that simple!
Thanks a lot Tom - my problem is solved.
Br
Anders