I am trying to dummy-proof a worksheet and I want an easy way to protect
and unprotect the worksheets without having to go Tools --> 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.
and unprotect the worksheets without having to go Tools --> 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.