Yes, there is a built in function for you that'll return true or false
depending on if it's locked or not.

Here's a quick function I wrote for you
Function isLocked(ByVal row As Integer, ByVal column As Integer) As Boolean
isLocked = Cells(row, column).Locked
End Function


This is a test sub routine for you to see how it works.
Sub test()
If isLocked(1, 1) Then
MsgBox "Row 1, Col 1 is locked"
Else
MsgBox "Row 1, Col 1 is NOT locked"
End If
End Sub

Kenjiro Yagi




"biglautz" wrote in message
...
Is there a tool I can run or maybe even a macro that would show me what
cells
are locked or unlocked. I have a big worksheet that has a big mix of
protected and unprotected cells, so I am trying to find a short cut to see
which cells are which, without checking formating or entering data into
each
cell.