Login | Register
SearchMy Stuff
My ProfileMy PreferencesMy Mates RSS Feed
Reply to Topic
Author Discussion

Buzzer

Original Poster:

2,226 posts

123 months

[news] 
Thursday 3rd August 2006 quote quote 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

31,789 posts

133 months

[news] 
Thursday 3rd August 2006 quote quote all
www.straxx.com/excel/password.xla

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

krusty

2,363 posts

132 months

[news] 
Thursday 3rd August 2006 quote quote 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

31,789 posts

133 months

[news] 
Thursday 3rd August 2006 quote quote 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,363 posts

132 months

[news] 
Friday 4th August 2006 quote quote all
Works a treat. Cheers T
Advertisement

Buzzer

Original Poster:

2,226 posts

123 months

[news] 
Friday 4th August 2006 quote quote all
Thank you!

much appreciated!

Oakey

16,139 posts

99 months

[news] 
Saturday 5th August 2006 quote quote 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

94 months

[news] 
Monday 13th August 2007 quote quote 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,369 posts

110 months

[news] 
Monday 13th August 2007 quote quote all
A password to run it or edit it?

Scrufter

331 posts

94 months

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

Vee

2,396 posts

117 months

[news] 
Tuesday 14th August 2007 quote quote all
Download the free addin from www.robbo.com.au

Road2Ruin

2,851 posts

99 months

[news] 
Tuesday 14th August 2007 quote quote 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

94 months

[news] 
Tuesday 14th August 2007 quote quote 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

94 months

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

Mattt

15,550 posts

101 months

[news] 
Tuesday 16th December 2008 quote quote all
Found this thread via Google - thanks Tony smile

TonyHetherington

31,789 posts

133 months

[news] 
Tuesday 16th December 2008 quote quote all
The power of PH, hey?! biggrin

Mattt

15,550 posts

101 months

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

onlynik

2,868 posts

76 months

[news] 
Tuesday 16th December 2008 quote quote all
Passware is really good at opening protected files.

http://www.lostpassword.com/

greymouse

1 posts

66 months

[news] 
Friday 23rd January 2009 quote quote 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

688 posts

101 months

[news] 
Saturday 24th January 2009 quote quote 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.
Reply to Topic