Since 2016 I have been working with an VBA-featured Excel file for statistical data and calculations.
The worksheet structure and the VBA code is protected with a seven-letter password with only lower caps letters.
The password has always been the same and I have never had this problem before.
Last update in the file was in May this year.
Yesterday, when I tried to unlock the VBA code I get the message Wrong password.
I have over 50 of versions of this file so I started to try and open some of the older ones, but with the same result, password is wrong!
I know the password is correct and I can actually unlock the worksheets with it, but I am still not able to access the VBA code.
I have been through possible causes and the only thing that is changed since May is that my PC is replaced with a new one. But, I have been able to unlock the VBA code in other PC’s during the years, so this really doesn’t make any sense.
Does anybody have a clue what this is all about?
Best Regards
Peter Karlström
Midrange AB, Sweden