I wrote a macro quite a while ago in Excel and locked it with a
password. I've since forgotten the password, and I would to use some
of the code in the macro. Is there any way to by-pass or break the
password?


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=467190

Yes, but it will cost you. There are several available on the net. Do a
search.
Cheers,
Dave

"PGalla06" wrote in
message ...

I wrote a macro quite a while ago in Excel and locked it with a
password. I've since forgotten the password, and I would to use some
of the code in the macro. Is there any way to by-pass or break the
password?


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile:
http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=467190

You are basically going to have to try every combination of numbers and
letters you think you might have used..

Use Workbook.open method and pass the password..

you will have to create permutations of your password, then loop through
them and pass them to the workbook.open method..

example.. you KNOW your password was 4 characters long and didn't use digits.
in column a of a workbook , rows
1: aaaa
2: aaab
3: aaac
.....
x: zzzz

Loop through them all passing the password to the workbook.open routine.

turn warnings off so you don't have to keep hitting yes, yes , yes.

*** IF you are not sure how many digits, and or it's many. OR if you can't
narrow down characters/letters 2 things to keep in mind.

1) it will take an EXTREMELY long time to run (but will still work)
2) it will be unrealistic to put all combinations in a worksheet. you will
have to write some sort of function to generate all combinations of all
letters(look up recursion)

hth










"PGalla06" wrote:


I wrote a macro quite a while ago in Excel and locked it with a
password. I've since forgotten the password, and I would to use some
of the code in the macro. Is there any way to by-pass or break the
password?


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=467190

David

If you used the Tools Protection option when adding your password
then try this site. - Its free & has helped me in the past

http://www.straxx.com/excel/password.html


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=467190

Password recovery for VBA modules (macros) in Word and Excel documents
http://lastbit.com/vba

Does anyone have some code written that I could work from?


--
PGalla06
------------------------------------------------------------------------
PGalla06's Profile: http://www.excelforum.com/member.php...o&userid=24260
View this thread: http://www.excelforum.com/showthread...hreadid=467190