View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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