Phantom Spreadsheet Password

[ransomedbyfire]

I was toying with the idea of password-protecting a spreadsheet the other day via VBA code. I used the code

Password=passwordtext

but then removed it. Now, my spreadsheet thinks it has a password even though it doesn't, which means I cannot get into it any more. I have tried using password-cracking software to get in, but no password can be found (because I don't think there is one). Is there any way to get around this?

Thanks!

 

[Ruddles]

Whatever value was in passwordtext, that will be the password to your workbook.

Other than that, it's not permitted to discuss methods of bypassing password protection on this forum.

 

[VoG]

Try either TRUE or FALSE (I can never remember which it is).

This has occurred because you should have used

password:=

We do not as a rule discuss password recovery so I am locking this thread.