Protect cells
 

Is there a way that I can see which cells are protected without having to
select them and then go to Format/Cell.../Protection?
--
Thanks
Dave

Do you use Format|Conditional formatting?

If no, then you could do this:

Select your range (say A1:X99)
Then Format|conditional formatting
Formula is: =cell("protect",a1)

and give it a nice fill color.

You could even use a cell that would allow you to show it or hide that CF
formatting.

I used $A$1 in this formula:

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

Put Show in A1 and you'll see the locked cells. Change A1 and it's back to
normal.

=========
An alternative that I like better.

Customize a toolbar to include the locked icon.
Tools|Customize|Commands Tab|Format Category
Scroll down the list of commands and drag the "Lock Cell" icon to your favorite
toolbar (a new one just for your stuff????)

Then when you select a single cell, look at that icon. If it's depressed, the
cell is locked.



Dave wrote:

Is there a way that I can see which cells are protected without having to
select them and then go to Format/Cell.../Protection?
--
Thanks
Dave

--

Dave Peterson