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