Solved: Error Message when trying to highlight specific cell

[AnswerSeeker]

The code is looking for a specific cell and I would like to highlight this one, but I always get the error message: "Unable to set Color Property of the Interior class"?

[VBA]Sub CheckDatabase()
Dim x
Worksheets(1).Visible = xlSheetVisible
Worksheets(1).Activate
x = Index + 2
Cells(x, 2).Select
Selection.Interior.Color = vbYellow
End Sub[/VBA]

[p45cal]

Is the cell locked and the sheet protected?

[AnswerSeeker]

yes, it was. I unlocked it and now it is working, thx for this, Is there a way to get the code working and keep some parts of the sheet protected?

[p45cal]

[vba]Sub CheckDatabase()
Dim x
Worksheets(1).Visible = xlSheetVisible
Worksheets(1).Activate
Worksheets(1).Protect UserInterfaceOnly:=True
x = Index + 2
Cells(x, 2).Select
Selection.Interior.Color = vbYellow
End Sub
[/vba]

[AnswerSeeker]

It is working well.
thx