• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Break The Code

Logit

Active Member
The attached small project hides everything if the correct password is not entered. The challenge is to access the workbook and answer the following questions:

"What are the five answers ?"
"What is the name of the building ""

You should also provide step by step instructions how you accomplished gaining access. If you desire, your response can be sent privately.
 

Attachments

  • Challenge.xlsm
    26.5 KB · Views: 39
I attacked the file with Power Query (here I go againo_O)
- in the source I got to see user names and password
- and the equations for the 5 equation questions
- save workbook in xlsx, to get rid of protection
- unhide config sheet and answer questions over there
- then get stuck, since nothing was happening => had to crack your vba protection to see the comment in sheet1 to reveal the buildings' name in the vba editor.

In fact, just the last step would have done the trick in a single go. But I never did that before, and I had to google some.
 
Building: World Trade Center
Answers: 8,5,20,4,37

I did it the old fashioned way. Hex Editor.

1) Change file extension from .xlsm to .zip
2) Open the .zip file, Go to xl folder, extract the vbaProject.bin file to desktop
3) Open Hex Editor & search for DBP=
4) Change it to DPX=
5) Save & Close
6) Replace the vbaProject.bin in the .zip file with the altered one
7) Rename extension to .xlsm & open the file
8) It will throw a few errors so just click ok till they disappear DO NOT ENABLE CONTENT
9) Open Visual Basic > Tools > VBA Project Properties
10) In the Protection tab add a new password. I just used 1 as my password and then click ok
11) Save & Close - this is ensure that when you next open it, you don't get the errors. Also your password is now the new password to view the vba code
12) Open file and DO NOT ENABLE CONTENT
13) Open Visual Basic > ThisWorkbook and turn Secure.Show into a comment
14) Added module to write code to unhide the Config sheet
15) Save/Close/Reopen, run the unhide macro for Config sheet and you're done
 

Attachments

  • Challenge.xlsm
    29.9 KB · Views: 7
Back
Top