[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: how to tell when the user selects the find function - hippy

NickHK

12/12/2006 2:47:00 AM

Maybe you can use this. Not sure how protection will affect it.
http://www.dailydoseofexcel.com/archives/2006/08/21/capture-del...

NickHK

"Hippy" <Hippy@discussions.microsoft.com> wrote in message
news:EF952E52-317D-4CD9-A03C-C286BFF71CBF@microsoft.com...
> 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.