Maybe you can use this. Not sure how protection will affect it.
http://www.dailydoseofexcel.com/arch...-deleted-rows/

NickHK

"Hippy" wrote in message
...
I have a spreadsheet that is protected. When the user tries to find
something
an error returns (since the spreadsheet is protectted).

Is there a way to tell if the user executed the find function, turn off
protection, allow the find command to process and then turn protection
back
on.

I have the code in VB to unprotect and protect but cannot fiqure out where
I
determine if the user selected the find function.