| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting Select (Un)Locked Cells in Worksheet Protection
I cannot find a way in VBA for accessing the Select Unlocked Cells or Select
Locked Cells properties that appear on the list of allowed actions of the Protection dialog in Excel XP. Most of the other properties listed there seem to available with Protect. Does anyone know a way? (Does anyone else find the XP VBA help for Excel as annoying as I do? Many lists of xl constants and properties and/or their definitions appear to be missing or so well hidden I can't find them.) Thanks!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
setting Select (Un)Locked Cells in Worksheet Protection
ActiveSheet.EnableSelection = xlUnlockedCells
perhaps. -- Regards, Tom Ogilvy "rbyte" wrote in message ... I cannot find a way in VBA for accessing the Select Unlocked Cells or Select Locked Cells properties that appear on the list of allowed actions of the Protection dialog in Excel XP. Most of the other properties listed there seem to available with Protect. Does anyone know a way? (Does anyone else find the XP VBA help for Excel as annoying as I do? Many lists of xl constants and properties and/or their definitions appear to be missing or so well hidden I can't find them.) Thanks!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locked cells are still able to be selected with proper protection | Excel Discussion (Misc queries) | |||
| Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
| Setting worksheet protection password in VBA | Excel Programming | |||
Linear Mode
