Allow find function on protected sheet...?

[BigDelGooner]

Hi guys

I have a worksheet full of data where, when the sheet is protected, the 'Find' function (Ctrl F) will not work. When it is unprotected it it fine.

Any idea how I can keep the sheet protected but allow the 'Find' function to work?

Thank you in advance

 

[shg]

Protect the sheet with the option to allow users to select locked cells.

 

[BigDelGooner]

Perfect, thank you very much. Always such a simple answer!

 

[BigDelGooner]

Ahh..I thought this was sort but unfortunately it isn't.

Just went to change that on the sheet but it was already set to that.

When I try and search for something (that I know 100% is there) it says....Microsoft Office Excel cannot fund the data you're searching for.

Any other ideas guys?

 

[shg]

Is that 100% to three significant digits, or absolute certainty?

Try searching for something trivially there.

 

[BigDelGooner]

Ha ha! I was searching for the word 'charity' which it finds when the sheet is unprotected but not protected...

The sheet has almost 600 rows, do you think this has anything to do with it?

Thanks for your help.

 

[shg]

And you did indeed allow selection of locked cells? I had no difficulty with this.

The sheet has almost 600 rows, do you think this has anything to do with it?

No.

What version of Excel are you using?

 

[BigDelGooner]

Using Excel 2003 (the best my employer can provide!)

 

[neruad1977]

I have allowed to select protected cells
at excel 2007 ctrl+f works at protected sheet - now excel 2010 not allowing such
Any suggestions folks?
Cheers

 

[Learner4Good]

I have allowed to select protected cells
at excel 2007 ctrl+f works at protected sheet - now excel 2010 not allowing such
Any suggestions folks?
Cheers

This is what you need to do in order to use xtrl+f to work at protected sheets:

- Unprotect the sheet, sellect the cells in the sheet which you would search, right click, format cells, then go to protection tab. in there make sure the hidden box is unchecked, after saving and protecting the sheet, it should work, it did for me