ExcelBanter - Password in Visual Basic

Hi Rick
I successfully used this method the other day which makes use of a hex
editor program. Remember to work with a copy of the workbook you want
to crack - in case something goes wrong.

This is what I followed:

1. From the Internet, download HexEdit v1.03 - its freeware thanks to
the kind author.

2. Install and make sure the program works on your system.

3. Start up Excel and create a new workbook - it doesn't have to
contain anything.

4. Access the VBE for this new workbook, set a simple password for it
(one that you will remember!) and make sure 'Lock project for viewing'
is ticked.

5. Save the workbook and quit Excel.

6. Open up HexEdit twice, so that you have two windows to work in.

7. In the first window, open up the workbook you just created.

8. In the second window, open up the workbook you want to crack.

9. Back to the 1st window, click on the Find Menu and then type in
CMG
(Use capitals - it is case sensitive)

10. In the right hand section of the first window you will see
something like what is listed below. The password lies coded in this
section.

CMG="7C7ED05630D634D634D339D339"
DPB="F8FA54BB71BB71448FBC71A98689317E6CCD5F311BC64 25335302924E29CF1D7DBF37D41"
GC="7476D85E28DB29DB29DB"

11. By dragging the mouse (then Edit - Copy), copy everything from
the first quote in the CMG line to the last quote in the GC line.

12. Highlight this exact same area in this 2nd window for the
workbook you want to crack, and then paste over the code you copied
from the other workbook.

13. Save the edited workbook and quit HexEdit altogether.

14. Startup Excel and load the workbook you want to crack (the one we
just edited the code in).

15. Access the VBE and when it asks for a password, it should now be
the simple password you made for the other workbook.

In essence you do not find out what the original password was, you
simply replace it with a known password. Neat - a bit like gene
splicing!

This is not my original idea - I got this from someone else who posted
to this newsgroup sometime ago.

If you can't follow this, you can send me the file and I can have a
try for you if you like.

Regards

Andrew B

Perth WA

ricw wrote in message ...
Hi All,
I have inherited a problem. I ended up with some spreadsheets that a
co-worker built that has macro's. I am ok with building macros, but I
cannot get to his macros in VB because he added a password to it. He
has given me the 3 passwords that he said he used, but none of them
will allow me to view the script. I have an addin in Excel called
Navigator. It works great for cracking passwords in protected
spreadsheets, but I have not been able to use it for VB. Does anyone
out there know of an addin that would work for me? Help urgently
needed. Thank you,
Rick

---
Message posted from http://www.ExcelForum.com/