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

Insert Comments on a Protected Worksheet 1
Enabling Autofilter and Sorting in a Protected Sheet 2
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Returned position address on protected sheet 7
Sorting tables on protected worksheets 7
Sheet Protection 2
Spell Check Protected WORKBOOK 1
Disable Outlook AutoCorrect with GPO 0

Top