Test if cell is locked

[EssKayKay]

I’m looking for VBA code to test if a cell is locked. I know this is not correct but something like --

If Range(“M33”).Locked Then
Else
End If

Thanks,
Steve

 

[Joe4]

Just need to use "staight" double-quotes, not slanted ones, i.e.

If Range("M33").Locked Then
Else
End If

(and then tell it to do something!)

 

[EssKayKay]

Just need to use "staight" double-quotes, not slanted ones, i.e.

If Range("M33").Locked Then
Else
End If

(and then tell it to do something!)

Excellent - thank you very much Joe. I'll have to look at this later tonight. I'll keep you posted.