How to determine whether a protected sheet has a password?

's Computer Specifications

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

's Computer Specifications

That's the only way I know.

Jerry W. Lewis wrote:
>
> 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

--

Dave Peterson

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determine if a sheet is protected?	Robert Crandal	Microsoft Excel Programming	4	19th Jan 2010 12:55 AM
Determine if local user account is password protected	=?Utf-8?B?QmVu?=	Windows XP Security	0	28th Mar 2007 12:59 AM
Determine if PST file is password protected	static.chi.cubs@gmail.com	Microsoft Outlook	2	10th Nov 2005 06:57 PM
Re: Password Protected Sheet	Frank Kabel	Microsoft Excel Misc	0	23rd Sep 2004 08:09 PM
VBa, Password protected sheet fails to get unprotected with the same password	Hans Rattink	Microsoft Excel Programming	3	28th Jul 2003 02:30 PM