Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining which cells are locked.
Is there a way for Excel to indicate which cells are locked without having
to view the properties of each cell individually. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining which cells are locked.
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. PCLIVE wrote: Is there a way for Excel to indicate which cells are locked without having to view the properties of each cell individually. -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Determining which cells are locked.
Dave,
That's exactly what I was looking for. Thanks, Paul "Dave Peterson" wrote in message ... 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. PCLIVE wrote: Is there a way for Excel to indicate which cells are locked without having to view the properties of each cell individually. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
unlocked cells in excel 2000 now locked when opened in 2003 why? | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |