• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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.
  • 2
1 Solution
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.
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?

Arno KosterCommented:

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.
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now