Find Function not working on protected sheet
 

I'm not sure if this group can help but I have posted this question 3 times
to another post over the last five days and none of them show up.

I have a spreadsheet that is protected in the header section. The user
section (line 7 and greater) is not protected. After reading quite a few
posts I understand the find (or find replace) function is disabled on
protected, partially protected and shared worksheets. I would like to create
a function or procedure that would unprotect the sheet, perform the find and
then protect the sheet again if the user executes the find function. I have
the code to unprotect and protect. What I am looking for is something that
would tell me the user has requested the event so I can step in. Is there any
way to tell when the user performs an action like this?

Find Function not working on protected sheet
 

This question has been responded to in another post of mine. I entered the
group though a different path and now I am able to see the questions I posted
a couple of days ago.

"Hippy" wrote:

I'm not sure if this group can help but I have posted this question 3 times
to another post over the last five days and none of them show up.

I have a spreadsheet that is protected in the header section. The user
section (line 7 and greater) is not protected. After reading quite a few
posts I understand the find (or find replace) function is disabled on
protected, partially protected and shared worksheets. I would like to create
a function or procedure that would unprotect the sheet, perform the find and
then protect the sheet again if the user executes the find function. I have
the code to unprotect and protect. What I am looking for is something that
would tell me the user has requested the event so I can step in. Is there any
way to tell when the user performs an action like this?