ExcelBanter - How to determine whether a protected sheet has a password?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to determine whether a protected sheet has a password? (https://www.excelbanter.com/excel-programming/394335-how-determine-whether-protected-sheet-has-password.html)

Jerry W. Lewis

How to determine whether a protected sheet has a password?

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

How to determine whether a protected sheet has a password?

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

All times are GMT +1. The time now is 10:14 AM.