PistonHeads.com Forum

Anyone crack a password protected Excel Spreadsheet?

Anyone crack a password protected Excel Spreadsheet?

Author
Discussion

Buzzer

Original Poster:

2,581 posts

137 months

Thursday 3rd August 2006
quotequote all


Can anyone help with this? One of the guys at work created a spreadsheet which we have used extensively but he has now left the company and wont divulge the password…. I want to add a few more lines but cant because he has password protected it.

Anyone know how to crack it?

TonyHetherington

32,066 posts

147 months

Thursday 3rd August 2006
quotequote all
www.straxx.com/excel/password.xla

piece of cake, and so easy it's un true...

krusty

2,409 posts

146 months

Thursday 3rd August 2006
quotequote all
Tony, can you give a little more info please. I downloaded this but it didn't help on a xls sheet I was trying to get inside..
Cheers

TonyHetherington

32,066 posts

147 months

Thursday 3rd August 2006
quotequote all
ah sorry...

instructions are

"Loading this add-in in Excel gives you two extra menu-items on the "Tools"-menu (or equivalent in non-English versions of Excel). These are:

Unprotect workbook
Unprotect sheet
To load this add-in in Excel: Open it the same way you do with Excel workbooks. Installing the add-in does not work for all users."

taken from www.straxx.com/excel/password.html

So to summarise, open the document that's protected. Then open the password.xla file I linked to above. It loads as an add in in Excel so looks like not a lot's changed. ONce, however, it's loaded you get an extra menu in the tools menu: Unprotect sheet and unprotect workbook. Clicking either of them will do as such - it can take up to 1 or 2 minutes to do.

krusty

2,409 posts

146 months

Friday 4th August 2006
quotequote all
Works a treat. Cheers T

Buzzer

Original Poster:

2,581 posts

137 months

Friday 4th August 2006
quotequote all
Thank you!

much appreciated!

Oakey

18,331 posts

113 months

Saturday 5th August 2006
quotequote all
You know, I'm sure it's illegal to do things like that. If he created the work as an employee of the company and was paid for it, then I'm sure there's something about leaving and not divulging passwords to work.

Scrufter

331 posts

108 months

Monday 13th August 2007
quotequote all
Help.

I have excel spreadsheet where the Macro inside the spreadsheet has been passworded. I have tried the solutions described above but to no avail any one got any suggestions?

Mike

xiphias

5,552 posts

124 months

Monday 13th August 2007
quotequote all
A password to run it or edit it?

Scrufter

331 posts

108 months

Monday 13th August 2007
quotequote all
xiphias said:
A password to run it or edit it?
Edit, running it isn't a problem.

Vee

2,623 posts

131 months

Tuesday 14th August 2007
quotequote all
Download the free addin from www.robbo.com.au

Road2Ruin

3,024 posts

113 months

Tuesday 14th August 2007
quotequote all
Ahhhhh, not the old I've lost my password routine. Hmmmmm. Well I think I lost the my bank account details and need some more. Anyone care to send me theirs?

Scrufter

331 posts

108 months

Tuesday 14th August 2007
quotequote all
Road2Ruin said:
Ahhhhh, not the old I've lost my password routine. Hmmmmm. Well I think I lost the my bank account details and need some more. Anyone care to send me theirs?
As far as I can tell this is the first time any one has asked for way of getting a password for the Vba code for a macro.

So I'd like to think of this as new routine thank you very much.
smile

Scrufter

331 posts

108 months

Tuesday 14th August 2007
quotequote all
Vee said:
Download the free addin from www.robbo.com.au
Thanks will give it a try at work tomorrow

Mattt

15,843 posts

115 months

Tuesday 16th December 2008
quotequote all
Found this thread via Google - thanks Tony smile

TonyHetherington

32,066 posts

147 months

Tuesday 16th December 2008
quotequote all
The power of PH, hey?! biggrin

Mattt

15,843 posts

115 months

Tuesday 16th December 2008
quotequote all
I was trying to do work, and ended up on PH anyway!!

onlynik

3,185 posts

90 months

Tuesday 16th December 2008
quotequote all
Passware is really good at opening protected files.

http://www.lostpassword.com/

greymouse

1 posts

80 months

Friday 23rd January 2009
quotequote all
I'd recommend the soft that helped me recover a password to a VBA project in my Word document. It handles Excel spreadsheets too. Though its interface is a bit minimalistic this thing works properly. smile

http://apasscracker.com/products/vba-password.php


Wh00sher

821 posts

115 months

Saturday 24th January 2009
quotequote all
Road2Ruin said:
Ahhhhh, not the old I've lost my password routine. Hmmmmm.
We had a similar problem where an employee had left the company. He did the spreadsheet to `make the job easier`, no money involved, it was just one of those things that people do manually and he passworded it to stop anyone mucking it up.

He left and we needed to change the code slightly - (it had an autoprint to A3 and certain formatting that our new printer wouldn`t do) so we needed to access the VBA code.

Nothing sinister in it, just a genuine need to edit the sheet / VBA.