Forgot The Password For My Spreadsheet!

[jhiggins07]

Can anyone give me any tips or ideas of what to do?

The information in it is very important and I changed the password as I do regularly but cannot remember the password

 

[Minkey]

I have a macro that will remove the password - I'll PM it to you when I get home (in approx 3 hours) if no one else helps before then.

 

[jhiggins07]

Thank you very much that is greatly appreciated!

 

[unmarkedhelicopter]

Techniques for bypassing protection are not normally discussed on 'sensible' forums.
So :-
1. jhiggins07, if it is your sheet and you can prove that.
2. and you don't mind Minkey seeing it.

Then I suggest you send it him and he unlocks it and sends it you back.
These techniques are not secret but they have to be used with caution as they can expose an incredible amount of 'confidential' information. Usually someone who knows these techniques will have learnt (usually the hard way) to use them with restraint.

jhiggins07 if it's your bank details then you have also just learnt a valuable lesson in either keeping a record of your passwords or using security that can be easily bypassed. It's a tough lesson but this is also 'life'.

 

[Banana]

unmarkedhelicopter,

While I do agree with your misgivings about discussing how to break passwords, I want to point out, for everyone's sake:

I really, really, really do *hope* that this isn't the only security you have for your protected document.

Seriously, the password protection is nothing more than a tiny padlock. Heck, you don't need a steel cutter for the job; a lowly crowbar would be enough to break the password. The way it's implemented, there's several ways to break it.

The only sensible use of protecting is to ensure users do not mess with the document template and enter data in specified fields. But that's a non-security reason, and requiring password is at least an annoyance (I regularly flip between protected mode and unprotected mode), and at worse, totally useless.

So, yeah, anyway, don't use protection for security purposes.