Protection problem macro
A password breaking macro does not use the menus, so even if you could get
what you described, it wouldn't interfere with a macro.
Another problem with the whole concept of using a macro to stop a user is
that there is no way to make a macro run. A user can always disable macros.
--
Jim Rech
Excel MVP
"CLR" wrote in message
...
| 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
|
|
|
|
|