How to determine whether a protected sheet has a password?

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spell Checking on a protected sheet 1
Modifying a locked/protected sheet 3
Determine if a sheet is protected? 4
prompt password for a worksheet 5
How to Unlock Excel Workbook protected by MACRO Password 6
Macro can not unprotect a sheet in a shared workbook 4
Unprotect in a macro 4
Prevent User from Changing Password 2

Top