Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need code for disable selection of locked cells
Got code
Sub protect() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.EnableSelection = xlUnlockedCells ws.protect Password:="" Next ws End Sub I need to disable selection of locked cells Is there a function like ws.DisableSelection = xlLockedCells? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
cell selection appears to be locked | Excel Discussion (Misc queries) | |||
cell selection appears locked. How do I unlock it. | Excel Worksheet Functions | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Help : Code for selection non-contiguous cells | Excel Programming |