Worksheet Security Breaker
 

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

Worksheet Security Breaker
 

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



Damien wrote:

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