Protected Sheets - Viewing Cells that have been Unlocked
Protected Sheets - Viewing Cells that have been Unlocked
(OP)
I created and excel spreadsheet. Then I selected a few cells. I right clicked and selected "Format Cells", then I unchecked "Locked". I then Protected the sheet so that I could only change the cells that I selected intially.
I am trying to find out if there is way to view the cells in the sheet that are unlocked.
Appreciate your help.
I am trying to find out if there is way to view the cells in the sheet that are unlocked.
Appreciate your help.





RE: Protected Sheets - Viewing Cells that have been Unlocked
When I unlock a cell, I always change its colour at the same time. (I want users of my spreadsheets to be instantly aware of where they are able to enter data.) I use a subtle shade of pale yellow, just yellow enough to stand out on a LCD screen, but not so bright as to show up when printed on a black and white printer.
RE: Protected Sheets - Viewing Cells that have been Unlocked
RE: Protected Sheets - Viewing Cells that have been Unlocked
RE: Protected Sheets - Viewing Cells that have been Unlocked
On a side note, you can define a style for the input cells so that they'll all look the same.
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Protected Sheets - Viewing Cells that have been Unlocked
I guess I can go and select all the cells and lock them all again. Then Unlock the cells that I am intersted in and make sure only those are unlock.
Thanks
RE: Protected Sheets - Viewing Cells that have been Unlocked
It gives you a list of cell addresses that are unlocked. Modify as you like (you can for example shade all these cells)
CODE
Cheers,
Joerd
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Protected Sheets - Viewing Cells that have been Unlocked
(I color my unprotected "input" cells green for easy identification, then print in black and white.)
RE: Protected Sheets - Viewing Cells that have been Unlocked
Thanks
RE: Protected Sheets - Viewing Cells that have been Unlocked
http://www.asap-utilities.com/