Workbook promtps for password on open

I am not sure what I did to get this to happen.

I have been protecting the worksheets/workbook from changes but somehow it is getting password protected on open. I think maybe some code I did set it. It is a password I was using for protecting the worksheets.

How do I get it to stop do that?

Well, manually, you can unprotect it using the Tools->Protection menu option - if you know the password, that is. Is that what you mean?

Well, I figured it out.

I created a public variable for my password, which i named password.
So when I set

Password = whatever

It password protected viewing the document. Yikes!

I hope maybe this helps someone else with this problem

That's why it's a good idea to use some sort of prefix-scheme in VB. MS-Application parameters don't use prefixes, so if you do, you can be sure that there will be no clashes: "strPassword" would be quite safe, for instance.