Are you using Format|Conditional formatting?

If yes, then ignore this response.

If no, you could select your range (whole sheet???) and use:
format|conditional formatting
formula is: =CELL("protect",A1)
(with a1 the active cell.)


If you wanted to toggle this on/off, you could put some flag in a cell (I used
$a$1) and check that:

=AND(CELL("protect",A1),$A$1="Show")

If I put Show in $a$1, then all the locked cells will have that conditional
formatting. If I want to turn it off, I just clear the contents of A1.



biglautz wrote:

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.

--

Dave Peterson