View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR[_2_] CLR[_2_] is offline
external usenet poster
 
Posts: 28
Default Protection problem macro

Hi All...........

Would it be possible to have a Macro that would, upon opening a workbook,
just sit there and wait, whether the user does some cell entries or not,
but when they particularly do the sequence Tools Protection and either
"Unprotect sheet" or "Unprotect workbook" the macro would come alive and
cause the whole workbook to close without saving......."unless" the user had
entered the code "1.5" in a particular cell (say F3) before they did that
sequence? Or, if this isn't feasible, perhaps another method that would
prevent a "password busting" programs from working.

Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3