Protecting/Unprotecting

Hi All,

I have a workbook that I save as unprotected, but when I reopen it it asks for a password. I did designate a password for certain things in my VBA programing, but that code doesn't run until you put in the password upon opening the document. (The password that opens the document is the same in the code)

Therefore, I believe the issue is with a user setting in Excel that I can change. However, I have no idea what that is. Hopefully I have explained myself clearly.

Thank you for your help!

Good evening ExcelNut

Once a file has been saved with a password, that password will be applied every time the workbook is saved until you tell it not to.

Go to File > Save As, then click on Tools, General Options and clear the password boxes, and save with the name unchanged. This should remove the password.

HTH

DominicB