| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching for locked/unlocked cells
Hi All
I have a spreadsheet which has many cells locked, and they are spread all across my worksheet. I want a code which will help me select locked/unlocked cells (as required) in the selected range in one go. Something like 'Visible cells only' and 'Blanks' options available in the 'Go to Special' screen. A macro that asks me "Go to:" Locked Cells Unlocked cells Thanks a lot Karthik Bhat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Viewing of protected locked or unlocked cells | Excel Worksheet Functions | |||
| Display locked or Unlocked cells | Excel Discussion (Misc queries) | |||
| Scope priviledges for locked/unlocked cells | Excel Discussion (Misc queries) | |||
| paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
| Highlighting locked or unlocked rows, Searching cells | Excel Programming | |||
Threaded Mode
