Results 1 to 3 of 3

Thread: How To Protect VBA Project From Unauthorized Access

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0

    How To Protect VBA Project From Unauthorized Access

    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

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    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 and COM Add-Ins.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0

    Unfortunately, I imagined that this could be the solution
    Thanks and regards
    Lucio

Similar Threads

  1. Replies: 6
    Last Post: 09-03-2019, 10:26 AM
  2. VBA Trick of the Week:: Protect Worksheet for User Actions Only
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 1
    Last Post: 07-26-2013, 03:10 PM
  3. VBA Code To Protect Sheet With Only A Few Cells Unlocked
    By rich_cirillo in forum Excel Help
    Replies: 3
    Last Post: 07-04-2013, 06:47 PM
  4. Embed ms project in a table in ms word
    By hometech in forum Word Help
    Replies: 6
    Last Post: 09-27-2012, 12:57 PM
  5. Project Planner
    By littleiitin in forum Download Center
    Replies: 0
    Last Post: 09-03-2011, 07:46 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •