Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Seeing Protected Cells
Is there a way to see which cells are protected without having to open
"Format/Cells.../Protect"? -- Thanks Dave |
#2
|
|||
|
|||
Good evening Dave This routine will work, but only on a range, so select the range you want to check and run the macro. All cells are protected in a new spreadsheet by default, so this routine will select all the UNPROTECTED cells. Sub UnlockCell() Count = 0 On Error Resume Next For Each Rng In Selection If Rng.Locked = False Then Count = Count + 1 If Count = 1 Then Set Unlocked = Rng If Count < 1 Then Set Unlocked = Union(Unlocked, Rng) End If Next Rng Unlocked.Select End Sub HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=379837 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected Cells | Excel Discussion (Misc queries) | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
move between unlocked cells on protected sheet | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |