| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show Locked Cells
How can I figure out which cells on a sheet are locked? I'm to check an
originator's locking before putting the workbook up. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Locked Cells
Try this small macro:
Sub findlocked() Dim rr As Range Set rr = Nothing For Each r In ActiveSheet.UsedRange If r.Locked = True Then If rr Is Nothing Then Set rr = r Else Set rr = Union(rr, r) End If End If Next If rr Is Nothing Then Else rr.Select End If End Sub -- Gary''s Student - gsnu200810 "Evan Weiner" wrote: How can I figure out which cells on a sheet are locked? I'm to check an originator's locking before putting the workbook up. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show Locked Cells
Instructive! I merely added a MsgBox for the sheet protection mode. ...
Thanks! "Gary''s Student" wrote: Try this small macro: Sub findlocked() Dim rr As Range Set rr = Nothing For Each r In ActiveSheet.UsedRange If r.Locked = True Then If rr Is Nothing Then Set rr = r Else Set rr = Union(rr, r) End If End If Next If rr Is Nothing Then Else rr.Select End If End Sub -- Gary''s Student - gsnu200810 "Evan Weiner" wrote: How can I figure out which cells on a sheet are locked? I'm to check an originator's locking before putting the workbook up. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| locked cells | Excel Worksheet Functions | |||
| Locked cells show up in Apple Works | Excel Discussion (Misc queries) | |||
| show locked cells | Excel Discussion (Misc queries) | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Linear Mode
