| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
clearing unlocked fields on a protected sheet
I know that my cmd button code can unlock a worksheet, then step through a
list of named ranges to clear, but is there a better way, say using "For each...next" to step trhough each cell in a named range to test for the "unlocked" cells, then clearing? Can you address each cell as a range in a collection of ranges using For...each? DM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unlocked Cells in Protected Sheet | Excel Worksheet Functions | |||
| How do I create a comment on an unlocked cell in a protected sheet | Excel Discussion (Misc queries) | |||
| allow comments, unlocked cells, protected sheet | Excel Programming | |||
| move between unlocked cells on protected sheet | Excel Discussion (Misc queries) | |||
| Formatting unlocked cells on protected sheet | Excel Programming | |||
![Dick Minter[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
