PistonHeads.com Forum

Anyone crack a password protected Excel Spreadsheet?

Anyone crack a password protected Excel Spreadsheet?

Author
Discussion

Buzzer

Original Poster:

2,664 posts

142 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,078 posts

152 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,410 posts

151 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,078 posts

152 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,410 posts

151 months

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

Buzzer

Original Poster:

2,664 posts

142 months

Friday 4th August 2006
quotequote all
Thank you!

much appreciated!

Oakey

18,963 posts

118 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

113 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,732 posts

129 months

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

Scrufter

331 posts

113 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,715 posts

136 months

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

Road2Ruin

3,065 posts

118 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

113 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

113 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,942 posts

120 months

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

TonyHetherington

32,078 posts

152 months

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

Mattt

15,942 posts

120 months

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

onlynik

3,252 posts

95 months

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

http://www.lostpassword.com/

greymouse

1 posts

85 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

908 posts

120 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.