PDA

View Full Version : How To Protect VBA Project From Unauthorized Access



lucio5295
11-29-2013, 08:23 PM
Good morning,
I usually protect my VBA codes with password, but I know that this security can be easily broken by using commercial utilities.
To try to limit this problem, I would write a event handler procedure in degree of determining if the VBE window has been opened and the VBAProject is fully listed in the projects window (working in a similar way to the Workbook_Open event)

Can you give me some idea?

Thanks and regards
Lucio

Excel Fox
11-30-2013, 02:11 PM
There is no object class event handler which binds the Visual Basic Editor environment within Office application suites. So the direction you thought of is irrelevant.
Since you already seem to have agreed to the knowledge that Office VBA security is practically of no value to the savvy ones, I'm not going to reiterate that fact in any other way.

It is a very old cliche in the Excel world that you can only hope to really secure your code, by using DLL (http://support.microsoft.com/kb/815065) and COM Add-Ins (http://msdn.microsoft.com/en-us/library/office/aa141383%28v=office.10%29.aspx).

lucio5295
12-01-2013, 02:09 PM
:confused:
Unfortunately, I imagined that this could be the solution
Thanks and regards
Lucio