Hi again,

I've done something incredibly stupid. I was making a VBA form in excel, and
I used the password protect function to lock the VBA code... But somehow or
rather, i've seemed to have forgotten or mystyped the password when setting
it. Is there any way I could retrieve the code?

I don't think a brute force dictionary attack would work, since I *think* I
used a Latin phrase as my password. Can someone please help? I've tried some
of the demo programs on the net, but they don't seem to work. They didn't
seem to detect it.

Otherwise... I might have to spend another two days or so writing the
calculations again... Which i'd rather not do.

I created the password thing by going the Visual Basic screen that opens
when you press Alt+F11, and then right clicking on the tab that represented
my spreadsheet. I clicked on the Properties, and put the password in there.

The excel spreadsheet was created using Excel 2003.

Thanks in advance!

Regards,

Iwan Juwono

I'm not aware of any freeware that will crack VBA project passwords. The best
commercial one I'm aware of can be found by following the link below

http://www.lostpassword.com/

but I'm not too certain how it would get on with latin. If it doesn't
contain personal or confidential information you could upload it to

http://savefile.com/

Post the link to the file and I'll have a go with passware when I get home
later today.
Errare humanum est

Mike

"Harimau" wrote:

Hi again,

I've done something incredibly stupid. I was making a VBA form in excel, and
I used the password protect function to lock the VBA code... But somehow or
rather, i've seemed to have forgotten or mystyped the password when setting
it. Is there any way I could retrieve the code?

I don't think a brute force dictionary attack would work, since I *think* I
used a Latin phrase as my password. Can someone please help? I've tried some
of the demo programs on the net, but they don't seem to work. They didn't
seem to detect it.

Otherwise... I might have to spend another two days or so writing the
calculations again... Which i'd rather not do.

I created the password thing by going the Visual Basic screen that opens
when you press Alt+F11, and then right clicking on the tab that represented
my spreadsheet. I clicked on the Properties, and put the password in there.

The excel spreadsheet was created using Excel 2003.

Thanks in advance!

Regards,

Iwan Juwono

Have a look at this NG thread:
http://shorterlink.co.uk/12699
Good chance it will help you out.

RBS


"Harimau" wrote in message
...
Hi again,

I've done something incredibly stupid. I was making a VBA form in excel,
and
I used the password protect function to lock the VBA code... But somehow
or
rather, i've seemed to have forgotten or mystyped the password when
setting
it. Is there any way I could retrieve the code?

I don't think a brute force dictionary attack would work, since I *think*
I
used a Latin phrase as my password. Can someone please help? I've tried
some
of the demo programs on the net, but they don't seem to work. They didn't
seem to detect it.

Otherwise... I might have to spend another two days or so writing the
calculations again... Which i'd rather not do.

I created the password thing by going the Visual Basic screen that opens
when you press Alt+F11, and then right clicking on the tab that
represented
my spreadsheet. I clicked on the Properties, and put the password in
there.

The excel spreadsheet was created using Excel 2003.

Thanks in advance!

Regards,

Iwan Juwono

hi,
there is alot of freeware to crack passwords. excel security is not that good.
http://www.cpearson.com/excel/password.htm
http://www.mcgimpsey.com/excel/fileandvbapwords.html
http://www.nirsoft.net/utils/accesspv.html

go a google. you'll find more.

Regards
FSt1


"Harimau" wrote:

Hi again,

I've done something incredibly stupid. I was making a VBA form in excel, and
I used the password protect function to lock the VBA code... But somehow or
rather, i've seemed to have forgotten or mystyped the password when setting
it. Is there any way I could retrieve the code?

I don't think a brute force dictionary attack would work, since I *think* I
used a Latin phrase as my password. Can someone please help? I've tried some
of the demo programs on the net, but they don't seem to work. They didn't
seem to detect it.

Otherwise... I might have to spend another two days or so writing the
calculations again... Which i'd rather not do.

I created the password thing by going the Visual Basic screen that opens
when you press Alt+F11, and then right clicking on the tab that represented
my spreadsheet. I clicked on the Properties, and put the password in there.

The excel spreadsheet was created using Excel 2003.

Thanks in advance!

Regards,

Iwan Juwono

Thank you, all three of you! The websites helped a lot and I was able to
recover my code.

Thank you, again!