I am trying to dummy-proof a worksheet and I want an easy way to protect and unprotect the worksheets without having to go Tool --> Protection --> etc.
I know how this can be done if the protection is used without the password, but I WANT to use the password protection. Can code be written so that the Password dialog box automatically pops up (when protecting AND unprotecting)? Thanks in advance.
I know how this can be done if the protection is used without the password, but I WANT to use the password protection. Can code be written so that the Password dialog box automatically pops up (when protecting AND unprotecting)? Thanks in advance.