| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using FIND on a protected worksheet
I have a spreadsheet that I am able to search (FIND) a given value just fine.
Once I protect the sheet the find no longer works. The message returned is "Microsoft Office Excel cannot find the data you're searching for" Note: The spreadsheet is partially protected. The value I am searching for is in the unprotected area. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using FIND on a protected worksheet
Not clear what you mean with "partially protected"! A sheet is either
protected or not protected. Depending on how you protected you sheet - Select only unlocked cells, or select locked and unlocked cells, you would or would not be able to find a record. If you, on protecting the sheet, elected to only allow selection of unlocked cells, you will not find info in locked cells. You will however find info in unlocked cells. If you elected to select both locked and unlocked cells, you will find info in both locked and unlocked cells. -- Hth Kassie Kasselman "Hippy" wrote: I have a spreadsheet that I am able to search (FIND) a given value just fine. Once I protect the sheet the find no longer works. The message returned is "Microsoft Office Excel cannot find the data you're searching for" Note: The spreadsheet is partially protected. The value I am searching for is in the unprotected area. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using FIND on a protected worksheet
Kassie
I don't find this to be the case with my 2003 No matter which cells I lock or unlock and no matter whether or not I allow selection of locked or unlocked or disallow either or both my Fine still finds all on a protected sheet. Gord Dibben MS Excel MVP On Sat, 9 Dec 2006 11:59:00 -0800, kassie (Change all to lowercase) wrote: If you, on protecting the sheet, elected to only allow selection of unlocked cells, you will not find info in locked cells. You will however find info in unlocked cells. If you elected to select both locked and unlocked cells, you will find info in both locked and unlocked cells. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using FIND on a protected worksheet
Fine should have been Find
Gord On Sat, 09 Dec 2006 12:36:53 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Kassie I don't find this to be the case with my 2003 No matter which cells I lock or unlock and no matter whether or not I allow selection of locked or unlocked or disallow either or both my Fine still finds all on a protected sheet. Gord Dibben MS Excel MVP On Sat, 9 Dec 2006 11:59:00 -0800, kassie (Change all to lowercase) wrote: If you, on protecting the sheet, elected to only allow selection of unlocked cells, you will not find info in locked cells. You will however find info in unlocked cells. If you elected to select both locked and unlocked cells, you will find info in both locked and unlocked cells. Gord Dibben MS Excel MVP |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using FIND on a protected worksheet
Shows you how things develop hey.! I am using 2002, and as I said, if it is
in an unprotected cell, you can find it. If it is in aprotected cell, and the option to select protected cells is unticked, you don't -- Hth Kassie Kasselman "Gord Dibben" wrote: Fine should have been Find Gord On Sat, 09 Dec 2006 12:36:53 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Kassie I don't find this to be the case with my 2003 No matter which cells I lock or unlock and no matter whether or not I allow selection of locked or unlocked or disallow either or both my Fine still finds all on a protected sheet. Gord Dibben MS Excel MVP On Sat, 9 Dec 2006 11:59:00 -0800, kassie (Change all to lowercase) wrote: If you, on protecting the sheet, elected to only allow selection of unlocked cells, you will not find info in locked cells. You will however find info in unlocked cells. If you elected to select both locked and unlocked cells, you will find info in both locked and unlocked cells. Gord Dibben MS Excel MVP |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using FIND on a protected worksheet
I never noticed that when using 2002.
I have uninstalled so can't test but you seem to have done the testing so we'll leave it at that. Thanks On Sat, 9 Dec 2006 20:24:00 -0800, kassie (Change all to lowercase) wrote: Shows you how things develop hey.! I am using 2002, and as I said, if it is in an unprotected cell, you can find it. If it is in aprotected cell, and the option to select protected cells is unticked, you don't Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I unprotect a text box in an otherwise protected worksheet | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
| Import/Export XML in protected worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
