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?

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?