when the sheet is protected, the find funtionality doesnt return any result.
Why is it so & how can we enable data to be found when the sheet is protected?

Why is it so? Not trying to be rude, but that's the way it was designed.
Unprotect the sheet before using the find function. If you are doing this
in code, then if you've got the sheet in question 'selected'/active:
ActiveSheet.Unprotect
....do the .Find
Activesheet.Protect
or if it is another sheet than the current ActiveSheet
Worksheets("sheetname").Unprotect
....do the .Find
Worksheets("sheetname").Protect

if you need to supply a password, then add
password:="sheetpassword"
to both commands - where "sheetpassword" is the actual password for the sheet.

"Ram" wrote:

when the sheet is protected, the find funtionality doesnt return any result.
Why is it so & how can we enable data to be found when the sheet is protected?