VBA error 1004-password incorrect caps lock on

[soleturnes]

Hi! I have an excel file with some macros, which i've been using for a while, that protect and unprotect the workbook, with the password written in the code, but for some reason it isn´t recognizing now the password.
The password hasn´t been changed.
Could someone please help me?

I'll post my code below, but it works fine with other files.

Code to unprotect:
ActiveWorkbook.Protect Password:="xx", Structure:=False

I've already tried without success:
ThisWorkbook.Protect Password:="xx", Structure:=False
Workbooks("NAME").Protect Password:="xx", Structure:=False
ActiveWorkbook.UnProtect Password:="xx"
ActiveWorkbook.UnProtect (["xx"])
Opening it in Safe Mode

When trying to unlock the workbook in the review tab I get the same error

Thanks!

 

[rlv01]

I hate to be the bearer of bad news, but if it's the same code that has been working for a long time, and if you cannot unlock it manually then it suggests two possibilities:

1. Somehow (this usually means 'someone') the password was changed.
2. The file is corrupt and the valid password is not recognized because stored password hash is corrupt.

 

[Joe4]

Welcome to the Board!

I have to ask/rule out the obvious here.

Based on the title of your thread:

VBA error 1004-password incorrect caps lock on

Are you sure that the issue isn't that the Caps Lock button is on while you are trying to enter the password?
If you toggle the Caps Lock button (press it once), and then re-enter the password, does it work then?

 

[soleturnes]

Welcome to the Board!

I have to ask/rule out the obvious here.

Based on the title of your thread:

​

Are you sure that the issue isn't that the Caps Lock button is on while you are trying to enter the password?
If you toggle the Caps Lock button (press it once), and then re-enter the password, does it work then?

Yes, i´ve tried the caps lock button and copy/paste it , and also it's written in the code and after debugging it, gives the same error

 

[Joe4]

Then I concur with what rlv01 has said.
Most likely either it has a different password, or the workbook has become corrupted.

 

[soleturnes]

I hate to be the bearer of bad news, but if it's the same code that has been working for a long time, and if you cannot unlock it manually then it suggests two possibilities:

1. Somehow (this usually means 'someone') the password was changed.
2. The file is corrupt and the valid password is not recognized because stored password hash is corrupt.

I don't think someone could change the password because the VBA is locked with another password that only I know. Could someone changed it in the review tab?
How could it became corrupt? is there a way to fix it?

Thanks!!

 

[dave3009]

Usually people keep a blank master version and frequent backups of their data/workbooks, that way if the worst happens then you can extract the data and revert everything back to how it was. If you don't do that, then now might be a good time to start.

 

[soleturnes]

Usually people keep a blank master version and frequent backups of their data/workbooks, that way if the worst happens then you can extract the data and revert everything back to how it was. If you don't do that, then now might be a good time to start.

I do, but wanted to know if it was fixable as I can´t find an explanation for this error

 

[Joe4]

There are numerous ways your file can be corrupted.
This link shows you 5 of the most common: 5 Reasons your Excel Files get Damaged & Corrupted | Commercial Construction and Renovation

Also, before we get too far down this path, I just want to point out rule 6 here, in the list of our rules: Message Board Rules

 

[dave3009]

I do, but wanted to know if it was fixable as I can´t find an explanation for this error

Another thing to consider is a log sheet of some description. During a before close event you can test if the password in use matches what it should be, if not log the error with user details, better still have it send you a message via CDO mail.