Find Function on Excel 2007

Hi All,

I have an excel spreadsheet which needs to be protected.

Problem, Once I protect the workbook, I cannot find on it anymore.

Is it possible to be able to find (Ctrl+f) on the worksheet once it is protected.
thorpey83Asked:
Who is Participating?
 
Arno KosterConnect With a Mentor Commented:
TinTombStone,

the find function in itself does work on protected excel sheets, both in 2010 and in 2007 versions.
When the protection option disables selecting cells however, it will be rendered useless.
0
 
Arno KosterCommented:
In order to be able to use the Find option, you should allow the user of the protected worksheet to select protected cells and to select unprotected cells (the first two option checkboxes).

You can do this by unprotecting the spreadsheet and then protecting it again.
0
 
TinTombStoneCommented:
Find works fine on a protected Excel 2010 sheet.  Can't see why it would be different on 2007

Does the Find Dialog open when you press Ctrl+F?  
Does it open from the the Home tab?


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.