Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
View which cells are locked?
Hi All,
Is there any way to visually see which cells are locked and/or which cells are unlocked? TIA, Sammy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
View which cells are locked?
This little macro will find locked cells within the used range:
Sub SeeLocked() Set ll = Nothing For Each r In ActiveSheet.UsedRange If r.Locked = True Then If ll Is Nothing Then Set ll = r Else Set ll = Union(ll, r) End If End If Next If ll Is Nothing Then MsgBox ("nothing locked") Else ll.Select End If End Sub -- Gary''s Student - gsnu200802 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked view | Excel Discussion (Misc queries) | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
locked cells | Excel Discussion (Misc queries) | |||
locked cells | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |