macro to hack in to another secured wkbk

[cwunderlich]

So here is what I have:

I have created a wkbk which has a macro automatically run upon opening the wkbk. First, the Enable/Disable macro pop up appears. Then, if you click "Enable Macros", a userform pops up asking for a password. If this password is entered correctly, the macro runs and unhides all sheets (which has sensitive info on them that only the user who knows the password should be able to open). However, if you select, the "Disable Macros" option, the wkbk just opens like normal and keeps the sheets with the sensitive info all hidden (the user can then only see 1 sheet, a sheet that should be visible to anyone opening up the file).
I have also put a password on the VBA code within the file.

I am now testing to see if this can be hacked into w/o knowing the file password. I have created a macro in a separate wkbk which opens up the secured file. I am trying to have the macro open this secured wkbk with the "Disable Macros" option. Is there a way to have a macro automatically open a wkbk in this manner? Im sure there is, I just don't know the syntax.

My thought is: that if I can get the macro to open the secured wkbk with the disable macro option, I can then have that same macro run an "Unhide All sheets" sub() that I have created, which will allow the hacker to see all the sheets.

Any help is much appreciated and let me know if this is not clear or if you have any questions.

I need this by the end of today... so plz help!!! and thanks!!

 

[RoryA]

Excel is not secure. Your passwords can be easily overcome without code. If it's an issue, you need to use another platform.