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!!

 

[MrKowz]

In short, yes there is.

However, discussion about password cracking, hacking, or bypassing Excel security is strictly forbidden on these forums.

See rule 20.

 

[cwunderlich]

better yet, since I am pretty sure I can find a way for another macro to hack into this.

Is there a way to have the secured wkbk prevent/block any other macros from doing this sort of thing to it???

 

[JamesW]

H ithere,

Please read section 20 of the posting guidelines:

http://www.mrexcel.com/forum/showthread.php?t=127080

 

[Juan Pablo González]

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.

No, there isn't. In fact, that's one workaround to force the user to enable macros, have another file, or an exe, that opens the file.

 

[cwunderlich]

oops... sorry.

can the question of how to prevent this sort of thing be asked/answered??

thanks

 

[RoryA]

Since this doesn't appear to be asking how to circumvent passwords per se, you want:

Application.EnableEvents = False

before you open the workbook. Set it back to True afterwards.

Edit to address the last question: no.

 

[cwunderlich]

so the question of whether or not it is possible for a file to block/prevent malicious macros can't be answered????!?

 

[RoryA]

No, I meant that your workbook can't block other macros.

 

[cwunderlich]

ok, thanks guys!