VBA Excel 97: Worksheet/book Protection with Password ?
Posted on 2002-04-30
No, _not_ another question about password cracking....
Do you know a way in VBA to determine whether the worksheet / workbook protection was done with or without (i.e. left blank) a password ?
If not: Do you know a way how to catch the return of the password prompting dialog which Excel pops up when you try to unprotect by VBA a worksheet without passing the required password ?
Background: The auditing arrows are very handy, but for some reason they do not work on a protected worksheet. I am making a work-around macro and I want it to re-apply the password at the end if one was present. A fixed dialog is too cumbersome, personally I never use a password (crackers costing ~20$), but some users do.