Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2002
    Location
    San Francisco, California, USA
    Posts
    54
    Thanks
    6
    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. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,235
    Thanks
    202
    Thanked 796 Times in 729 Posts
    Imo,

    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!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  4. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 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 OpenOffice.org 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
  •