Someone HACKED my locked excel document!!! Help

[ctjacobs2010]

[FONT=Arial, Helvetica, sans-serif]Recently at work I sent out a locked and password protected document so no one could change anything, yet someone was able to breakthrough the passcode and change stuff and see information that was personal and confidential. I thought everything was secure and no one could get access to it and he was able to go around it with VBA and macros coding and get into the document and mess with things. I had no idea this was even possible and am now in dire straight to figure out how it was done and how to best prevent it from here on out. Any help would be greatly appreciated!!![/FONT]

[FONT=Arial, Helvetica, sans-serif]Ctjacobs2010[/FONT]

 

[RoryA]

They don't need to access the VBA in that workbook, they can simply run it in another workbook. VBA passwords are also trivial to break.

 

[Redwolfx]

The reality of the matter is nothing is fool proof. All you can do is do your best to protect it., You can make the sheets veryhidden within VBA and unhide them via VBA (for most people that means they will need to activate VBA to get the sheet to run, Write VBA Code to relock sheets/workbook upon cell changes, lock the VBA Even with all of that if someone wants to get in bad enough, they will.

 

[spoon_db]

I mean WinRAR.

 

[ww4612]

i have discussed this topic in another topic. there is no secure way to lock your data. competent hackers can extract your confidential data from your excel file even without using excel. the only way to secure your data is to desin two seperated workbook. one contains nothing but text, input field and simple formula. another one hold your confidential data and formula. send the first workbook. and use macro to import data from the first workbook to the second workbook once they send it back.
that is how the organization i am working at handle things like that