View Single Post
  #3  
Old May 31st, 2006, 09:46 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: n/a
Default OT I would want protect my sheets of excel from a "password recovery" software... How?

Hi macropod,

Let me know if I have understend what you tell me:

I cant protect using excel psw cause psw recovery easyly crack my psw.

but I could do a macro like this:
"if psw=off;select all sheets+cancel all sheets+save all" ? I think this
could be a good protection
but.... i dont know how to do this...couse I dont know VB6 :-( could help me
with a little example?

Your download link: http://www.easy-sharing.com/471922/secret
formula.xls.html

Thank's
Luca

"macropod" ha scritto nel messaggio
...
In the final analysis, you can't. But you could code your worksheet so

that
macros test whether the sheet and vba project are protected and only

supply
critical details/functions if the protection is on.

Cheers