+ Reply to Thread
Results 1 to 2 of 2

Licensing excel spreadsheet for sale

  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Licensing excel spreadsheet for sale

    Hi Guys.

    Have spent 5 or 6 hours googling this with little luck I thought I would put this out for suggestions.

    This is what I want to achieve:

    - Create an excel based financial model.
    - Provide the financial model to potential customers on a 14 day trial:
    ---After the 14 days, if the customer does not purchase a licence, make the model inaccessible.
    ---When the customer purchases a licence, allow access to the model.
    ---Licences need to be bound to the user’s computer.
    -The tricky bit – I need to allow licensed users the ability to send their amended models to any other licensed user for review
    -Ideally protect the model so that formula / sheets cannot be copied out of the model (disable right click / ctrl + c?)


    Is there third party software that could easily manage this (that is not thousands of dollars)? Failing this, would it be possible to create an excel add-in that could manage this?

    Sorry all of that is a bit long! Any thoughts on how to best achieve this are much appreciated

    Cheers

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Licensing excel spreadsheet for sale

    Hi,

    The first thing to say is that you're dealing with an Excel application whose prime reason for existence was not to be a fully protectable bespoke application on the lines you're thinking. Excel does have rudimentary protection mechanisms but none that I know of for which there aren't tools out there which will hack the protection. That said,

    1. You could use a Workbook Open macro that detects when the current system date is greater than a date you've recorded in the macro and which immediately pops up a warning message and then immediately closes the workbook. You can protect the Visual Basic Environment with a password to prevent a casual user from seeing the control date and changing it.

    2. On the purchase of a licence you could either simply send them an unrestricted workbook, or in a similar manner to 1 above record a licence key in the workbook open macro, and have a licence number cell somewhere in the workbook that the user would use to enter the licence key you give them and which the workbook open event would first check. If the licence key check passes then the macro would bypass the evaluation period date check.

    3. I'm not aware that you can restrict Excel to a particular machine

    4. If the workbook is licensed and hence unrestricted then it could be sent to anyone whether they are a licensed user or not.

    5. You could disable the Ctrl-C key with a macro, but a simple way round would be to create another macro in another workbook that enables Ctrl-C
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] define exact number of products sale from multiple sale and returned sale orders
    By maabadi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 06:14 AM
  2. Calc Final Sale Price Including % of Sale?
    By kierenschneider in forum Excel General
    Replies: 1
    Last Post: 10-26-2009, 01:09 PM
  3. Sale of spreadsheet advice
    By Rimmers UK in forum Excel General
    Replies: 5
    Last Post: 10-20-2008, 10:11 PM
  4. Replies: 1
    Last Post: 01-30-2006, 05:10 PM
  5. [SOLVED] Looking for inside sale compensation spreadsheet
    By cgphx in forum Excel General
    Replies: 0
    Last Post: 03-23-2005, 01:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1