VBA Protect Function Applies the Wrong Password

Viewed 1084

I start the Workbook_Open event with this line of code

Table1.Protect Password = "Secret", UserInterFaceOnly:=True

However, when I try to unlock it with

Table1.Unprotect ("Secret")

it does not work.

The Password Cracker says, that a working password would be "AAAAAAAABABF"

How do I actually set "Secret" as the password.

2 Answers
Related