Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Viewing Protected Cells en mass
Is there an easy way to view/highlight all protected cells on a sheet at once ?
I have 12 sheets and I want to check all the right cells are protected in each. thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Viewing Protected Cells en mass
Hi,
I don't know of any built in way to do this, but the following macro should do it: Sub test() Dim ActiveRng As Range For Each cell In ActiveSheet.UsedRange If Not cell.Locked Then If ActiveRng Is Nothing Then Set ActiveRng = cell Else Set ActiveRng = Union(ActiveRng, cell) End If End If Next If Not ActiveRng Is Nothing Then ActiveRng.Select End Sub Cheers, Ivan. On Mar 27, 12:55*am, Mart wrote: Is there an easy way to view/highlight all protected cells on a sheet at once ? I have 12 sheets and I want to check all the right cells are protected in each. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Mass amount of pics corosponding with cells in excel | Excel Discussion (Misc queries) | |||
Viewing Comments on a Protected Spreadsheet | Excel Discussion (Misc queries) | |||
How to mass populate cells? | Excel Discussion (Misc queries) | |||
Viewing protected cells | Excel Discussion (Misc queries) | |||
Viewing Custom Views in a protected worksheet | Excel Discussion (Misc queries) |