Seeing that you guys were able to perform the find I went through my
spreadsheet again an switched around different things to see if I had
something set wrong.

My sheet is protected with my header section cells locked and lines 7 and
greater unlocked. I had the hidden option checked for all the cells. Once I
removed the hidden selection from the unlocked section I was able to use the
find function.

I am going to test this out a bit more. Thanks for the help! Since you guys
were able to do it, it made me look a bit deeper into my code.

"Gord Dibben" wrote:

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