Someone HACKED my locked excel document!!! Help

ctjacobs2010

Board Regular
Joined
Dec 12, 2013
Messages
56
[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]
 
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.
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top