Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

password protection for VBA

Latest post Sun, Jun 29 2008 7:21 PM by mvaughn. 2 replies.
  • Wed, Jun 18 2008 1:05 PM

    • venu
    • Top 75 Contributor
    • Joined on Tue, Jun 3 2008
    • Posts 4
    • Points 100

    password protection for VBA

     Dear All,

                   i am looking for a way to mask or hide my VBA from the user , but i know that ,there are softwares in the market which can hack the VBA password very easily . Is there a way where you can hide your VBA from the softwares or hackers.....

    Your valuable contribution is appreciated............

    Venu

    • Post Points: 37
  • Wed, Jun 18 2008 1:23 PM In reply to

    Re: password protection for VBA

    Only by offloading the code into a DLL, all other ways are prone to be hacked.

    But seriously, is your code woth that much that you are worried by it? Simple password protection deters most.

     

    Regards

    Bob

    • Post Points: 5
  • Sun, Jun 29 2008 7:21 PM In reply to

    • mvaughn
    • Top 500 Contributor
    • Joined on Sun, Jun 29 2008
    • Posts 1
    • Points 5

    Re: password protection for VBA

    There is a free product called Invisible Basic that's probably as close as you'll get. It removes comments, blank lines and indents then renames modules and declared variables. So if someone gets past your password they will have to spend a lot of time figuring out your code.

    Here is the link:

    http://invisiblebasic.sourceforge.net/

     

    -Michael

    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.