How to determine whether a protected sheet has a password?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way (other than trying to unprotect it without a password) to
determine whether a protected sheet has a password or not? The HasPassword
property is implemented for workbook objects, but not for sheet objects.

Jerry
 
That's the only way I know.
Is there any way (other than trying to unprotect it without a password) to
determine whether a protected sheet has a password or not? The HasPassword
property is implemented for workbook objects, but not for sheet objects.

Jerry
Click to expand...
 
Back
Top