software

Is there a way for Excel to indicate which cells are locked without having
to view the properties of each cell individually.
I added an icon to a toolbar
tools|customize|commands tab|format category
look for the quot;lock cellquot; 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(quot;protectquot;,a1)
Give it a nice format.

PCLIVE wrote:
gt;
gt; Is there a way for Excel to indicate which cells are locked without having
gt; to view the properties of each cell individually.

--

Dave Peterson

Dave,
That's exactly what I was looking for.

Thanks,
Paul

quot;Dave Petersonquot; gt; wrote in message
...
gt;I added an icon to a toolbar
gt; tools|customize|commands tab|format category
gt; look for the quot;lock cellquot; icon. In xl2003, it looks like a padlock.
gt;
gt; Then drag it to your favorite toolbar.
gt;
gt; You can select a cell and look at that icon. If it's depressed, the cell
gt; is
gt; locked.
gt;
gt;
gt; ===
gt; Another way if you're not using format|conditional formatting, you could
gt; select
gt; the cells (all of them???) and with A1 the the activecell:
gt;
gt; Format|conditional formatting
gt; formula is: =cell(quot;protectquot;,a1)
gt; Give it a nice format.
gt;
gt; PCLIVE wrote:
gt;gt;
gt;gt; Is there a way for Excel to indicate which cells are locked without
gt;gt; having
gt;gt; to view the properties of each cell individually.
gt;
gt; --
gt;
gt; Dave Peterson