close

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

J.E. McGimpsey explains it:
www.mcgimpsey.com/excel/removepwords.html
Damien wrote:
gt;
gt; I've got a bit of VBA which breaks worksheet protection, but on inspection,
gt; if I put a password of 'TEST' on a worksheet, it breaks it with
gt; 'AAABBBBBABB.'. Try it!
gt;
gt; Does anyone know how or why this works? Is it a bug, or is it to do with
gt; bits and bytes?
gt;
gt; Thanks

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄