Worksheet Security Breaker

[Damien]

I've got a bit of VBA which breaks worksheet protection, but on inspection,
if I put a password of 'TEST' on a worksheet, it breaks it with
'AAABBBBBABB.'. Try it!

Does anyone know how or why this works? Is it a bug, or is it to do with
bits and bytes?

Thanks

 

[Dave Peterson]

J.E. McGimpsey explains it:
http://www.mcgimpsey.com/excel/removepwords.html