| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to "Find Next" text in protected cells
I have a file with text names in first 3 columns and they are protected. Am
trying to use Find, Find Next command to find names in those 3 columns then place info in unprotected cells to right. Find All seems to give me a list of names being searched for but Find Next will not automatically go to cell with name being searched for when they're protected. Is there anyway to use this or another method to quickly search for and go to a desired name in a protected column and enter data in unprotected columns to right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count specific text that occurs in a range of cells | Excel Discussion (Misc queries) | |||
| How can I fill a series in Nonadjacent cells eg Text 1, Text 2 | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Linear Mode
