Hello FellowNewsgroupReaders,

To protect my work I add passwords to The various parts of my applications.
Looking around in the archives in search of the maximum lengths and
effective lengths there are various answers, possiblitities etc.
As a small example to the problem I encounter: a worksheet, protected in
Excel XP wit a passwordlength of 30 cannot be opened in Excel 2000. Only a
word of 15 (created in XP) will be accepted in 2000.

In the archives all kinds of different answers are whirring around, like a
password of 30 chars. need only 4 to be cracked etc.
I AM aware that one can crack passwords, no problem. I think of the
protection more as a safeguard.

So. I'm so bold to ask the universal and ultimate question -but now in
total- about passwords:

What is the maximum effective length of passwords for the following matrix?

97 2000 XP
Workbook

Workbook structure

Worksheet password

VBA Project


Regards,
Rob