"IF" sheet is protected with password

I'm always running into something.

Started using the new Auto Filter macro on purchase order responses this morning, and ran into an issue I hadn't considered.

The template I sent the suppliers is password protected, to keep them from altering the formulas. Most suppliers are 'dumping' the inforrmation into a copy fo this template, and the copy is NOT password protected, BUT.... not all of them.

I've run into examples this morning that were no protected at all, were protected, but not with a password, and were password protected with the original password, 'password'. (I know, but it's light security.)

Now I need to add lines at the beginning of my code to meet each of those possibilities.

If it's no protected, no biggie, ActiveSheet.Unprotect still won't return an error. If it's not password protected, ActiveSheet.Unprotect will unprotect it, but if it is password protected, how do I get a macro to enter the password, 'password', only if it needs to?

Here is the top part of the macro, any help would be appreciated:

Please Login or Register  to view this content.

Thanks, and have a good one.

Jerry

You are correct once again, DC. All I had to do was add the password, and it works either way.

I hope you'll have time to look at my other post regarding the first cell containing a number.

Thanks, and have a good one.