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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks