Find function in Excel with the Spreadsheet protected

[turps]

Hello

I have a spreadsheet worksheet that needs to be protected but that allows the user to use the find function.

With the WS protect and they use the find option they get the message
"Microsoft Excel cannot fing the data you're searching for. Check your search options, location and formatting."

Any ideas?



Regards

David

 

[xlbo]

Find should not be affected by protection. I cannot replicate that error message except by searching for something that is not there.

The only way find could possibly be affected by protection is to have the option to select locked cells turned off and even then, there is no error message - it just can't select the cell that the data is found in

Only conclusion I can come to is that you are searching for something that doesn't exist...

 

[turps]

Thanks for this. The spreadsheet had been set to hidden. Once I unchecked this it worked find.



Regards

David