Protection

L

Landyman

Silly question, but if you have forgotten your password for a protecte
sheet, is there anyway of getting round this
 
B

Bob Kilmer

Yes. The password can be "cracked." Do a search for the details. This is a
common question. I would have to look it up if I needed it, too.
 
G

Greg Wilson

You can actually unlock worksheet protection (exploiting a
bug) with just two lines of code. However, I don't wish
to make it public here. I mention this as a sobering
reminder about Excel's worksheet protection.

The following solution obtained from John Walkenbauch's
site requires at least a little VBA knowledge:

http://j-walk.com/ss/excel/faqs/pw.txt

Regards,
Greg
 
L

Landyman

THanks for your help, has helped me out of a pickle.

Is there anyway that will allow me to see what the old password was
More out of general interest than anythin else

CHeer
 
Top