Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2014
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts

    How to lock my VBA code to "Project is unviewable"

    Gurus,

    i have developed an add-in and i spent lot of time building it. i want to protect the vba module so that no body can penetrate into it.

    i know how to lock it with password. but it is easily breakable. i also know the trick of sharing the workbook and then changing it to add-in but that is also breakable.

    is there any way or a commerial software that can lock my VBA code?

    or is there a way to change and move my entire coding to the xll ?

    thanks.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    President,

    Welcome to the Lounge as a new poster!

    1. In the VBE select: Tools->VBAProject Properties...
      VBA Project Properties.JPG
    2. Check the box: Lock project for viewing
    3. Supply a password & confirm.
    4. Done.


    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    President (2014-10-03)

  4. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts
    There are password busters available for $25 or so on the Internet. Here's a site that offers another option (3rd method).

    http://www.wikihow.com/Protect-VBA-Code

    I have always understood the bottom line to be that anyone who really wants to get at the code can find a way to do so. I've never tried myself, but I do know that code I've written and thought to be locked and password protected has been busted. By that time that's been done, I've developed something better, so it's more of an annoyance than a threat.

  5. The Following User Says Thank You to richardbarrett For This Useful Post:

    President (2014-10-03)

  6. #4
    New Lounger
    Join Date
    Sep 2014
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts
    thank you both

Posting Permissions

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