Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    San Francisco, California, USA
    Thanked 1 Time in 1 Post

    What is necessary prior to commercializing a VBA macro?

    For Office 2003, 2007 and 2010. I am considering trying to sell one of my macros that I find very useful. What do I need to do to the macro with regards to security before I sell it (other than adding a password to the macro)? Also, is there a way to add code that will allow the program to stop working unless a licensing code is input? Are there any references books, etc. for what is necessary for your macro(s) before you sell them? How easy is it to break security features on macros, etc.?

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Manning, South Carolina
    Thanked 1,608 Times in 1,452 Posts

    You probably want to convert it into an Ad-in. You can search the net for how to do this. There are tons of programs out there to break the Excel passwords so my guess would unless you create your own password hashing program or purchase one breaking in wouldn't be to hard. Passwords are usually stored in the Registry so you can look up how to read/right to the registry from VBA, shouldn't be too hard to find. Don't forget to include a copyright notice in the comments of the code.

    Good luck.
    May the Forces of good computing be with you!


    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Silicon Valley, USA
    Thanked 94 Times in 90 Posts
    In the past, the password to protect the VBA project was weak. Not sure whether that has changed in the most recent versions of Word with the new file formats.

    Old thread: VBA Project locked (2002). Also, the earliest version of ignored the password on the VBA project and, if I recall correctly, displayed the code with REM at the beginning of each line.

Posting Permissions

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