Using Find on a protected worksheet

  • Thread starter Thread starter clayton
  • Start date Start date
C

clayton

I have unlocked and unhiden all the cells I want to be able to searc
and protected my worksheet with a password. When I try to use the exce
Find It will not find anything. If I unprotect the sheet the find work
great.
When protecting I am allowing users to select unlocked cells only.
have tried enabling all of the "allow" options but nothing works.
I am using Excel 2003.
How can I use FIND on a protected worksheet??
 
Please disregard... For some strange reason it is working now... I hav
no clue why....

HOWEVER! I really do NOT want to leave these cells open for people t
edit!

Is there a way to search while still having the cells locked
 
Back
Top