Using Find on a protected worksheet

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??
 
C

clayton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 7 Autofit row heights of merged cells in protected worksheet 0
Insert Comments on a Protected Worksheet 1
Protected Worksheets and Comments 1
Protected Worksheet 2
Enabling Autofilter and Sorting in a Protected Sheet 2
Sorting tables on protected worksheets 7
Find/Replace Event or Find/Replace for Protected Sheet ... 2
Still can select locked cells in protected sheet 11

Top