Hi,

You can't.

No matter how complex an excel password is, Excel converts it into a 12
characters string. the first 11 characters are either A or B and the last is
one of 95 characters in the ASCII range of 32 (space) to 126 (~Tilde) or
194,560 possible combinations so no matter what password you use one of those
combinations will remove the password.

There are several bits of code on the net that try each of those
combinations in turn.

In short Excel worksheet protection is to guard against inadvertant change
and will not deter the malicious for more than a few moments.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Barbara" wrote:

There is a code that has been found that opens our password protected files
even thought the sheet is protected is there a way to prevent this.
AAAAABBAABBf typed in will unlock the sheet and now that the majority of
people here know that I need to find a way to lock it up without having to
use a password to open the file (people need to see the content). Does
anyone know how to block this?