Consulting

Results 1 to 7 of 7

Thread: License Key (Or Something Like This)

  1. #1
    VBAX Regular
    Joined
    Oct 2010
    Posts
    85
    Location

    License Key (Or Something Like This)

    I am considering selling some Excel sheets, but don't know how to prevent free redistribution on unauthorized machines.

    I have looked into a few programs like LockXLS, but thought that was bit overkill and intrusive to the user.

    I was thinking of something very simple. For example, the user could send you something specific to just that machine (math id perhaps?) and you could send them a file back that has code. The VBA would have an algorithm that relates the two and checks to see if it is valid.

    I guess I am just looking for something very simple and unobtrusive. Any ideas?

  2. #2
    VBAX Contributor
    Joined
    May 2010
    Location
    Sydney, NSW, Australia
    Posts
    170
    Location
    Quote Originally Posted by aerodoc
    I am considering selling some Excel sheets, but don't know how to prevent free redistribution on unauthorized machines.

    I have looked into a few programs like LockXLS, but thought that was bit overkill and intrusive to the user.

    I was thinking of something very simple. For example, the user could send you something specific to just that machine (math id perhaps?) and you could send them a file back that has code. The VBA would have an algorithm that relates the two and checks to see if it is valid.

    I guess I am just looking for something very simple and unobtrusive. Any ideas?
    One potential issue with that is if the user upgrades their machine. If they have paid for a sheet which they then try to use on a new machine they will not be happy, Unless you are permanantly tethered to your machine to generate them a new one they will not be impressed.

    I suppose you could come up with some sort of system where they are given a challenge key, they then enter that and their password in to a site (which you would have to create) the site would then email the response to the user registered for that sheet.

    Make it happen once a month so not so intrusive that it is a pain but once it is locked for the month, it is permanantly locked until they get the response correct.

    Just thinking out loud here but that would probably work.

  3. #3
    VBAX Regular
    Joined
    Oct 2010
    Posts
    85
    Location
    Yeah, I understand. It's not an easy solution, but other programs use this approach. I know there are other software solutions to help out (i.e. LockXLS) but they all seems overly intrusive.

  4. #4
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Hi aerodoc,

    There really isn't anything you can do to protect an ordinary Excel file from 'unlicensed use'. Whatever form of protection you implement can most likely be broken very quickly. Hence software like LockXLS.
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    VBAX Regular
    Joined
    Oct 2010
    Posts
    85
    Location
    What are the other options besides LockXLS? Money is not really an issue, I am looking for the best solution available.

  6. #6
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I looked at AppSentinel a few years back and it seemed good. I think you would need to implement a VB DLL alongside with some key code and the AppSentinel checks, I couldn't figure how you could add it to VBA and keep it secure..
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  7. #7
    I can also suggest DoneEx XCell Compiler.

    http://doneex.com/

Posting Permissions

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