Thanks!

Dave Peterson wrote:

> I added an icon to a toolbar
> tools|customize|commands tab|format category
> look for the "lock cell" icon. In xl2003, it looks like a padlock.
>
> Then drag it to your favorite toolbar.
>
> You can select a cell and look at that icon. If it's depressed, the cell is
> locked.
>
>
> ===
> Another way if you're not using format|conditional formatting, you could select
> the cells (all of them???) and with A1 the the activecell:
>
> Format|conditional formatting
> formula is: =cell("protect",a1)
> Give it a nice format.
>
> Rich Pasco wrote:
>>
>> Using Excel 2003 on Windows XP, I would like to see at a glance which
>> cells are Locked and which are not, by automatically shading the
>> background of just the Locked cells. How can I do that?
>>
>> If that's too hard, is there any other way I can quickly tell which
>> cells are Locked, for example looking at a status line as I move the
>> cursor over the cells? or any other way that's faster than opening
>> Format/Cells/Protection on each cell one at a time?
>>
>> - Rich
>