+ Reply to Thread
Results 1 to 6 of 6

Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

  1. #1
    Registered User
    Join Date
    08-15-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    57

    Exclamation Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

    Hi,

    I would like Excel sheet to work for a certain period of time say like 30 days or so from the date its 1st used by someone, the issue are as below:

    a) I can ask the macro to check the date the sheet is 1st open and the copy and paste value and then count 30 days from it every time it open however if someone change the computer date it can work still.

    b) I would like the sheet to be valid for a particular duration say from 1st April of one year to 31st of the following year (Indian Accounting period), no idea how to do this.

    c) presently at the start of excel sheet a user form ask for user name and pass key to check his authorization to use and rights he have as detailed above I would like to check user right to use also ie how many days remained etc.


    I will be happy if anyone can help on Point B as i will probably will go that way.

    Note: in case of Option B Excel must not accept any date before and after the given date, I agree that can be done by giving validation but still if something better can be suggested.

    Thanks in Advance.

    Reg,
    CVishu

    (I am not using any other user form)

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

    Insert a new worksheet named "Hidden" and hide it, then use code like this (you will need to trust programmatic access to the VB Project) - the code will wipe out all the VBA code when the file is opened after more than 30 days beyond its first use. You should also lock the project, but remember that any moderately skilled Excel user will be able to defeat your scheme.

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    08-15-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    57

    Re: Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

    Hi,

    Thanks for the response, however getting the Compile Error "User Defined Type not Defined" for

    Please Login or Register  to view this content.
    Reg,
    CVishu

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

    Oops - my bad. I forgot to tell you that you need to set a reference to MS VBA extensibility in your project.

  5. #5
    Registered User
    Join Date
    08-15-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    57

    Re: Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

    Hi,

    Sorry for being so dumb but still dont understand what to name what, 1st i thought i have to make each form and sheet project name as "VBIDE.VBComponent" however it say BAD Name.

    Hope you can elaborate further on the matter.

    Many Thanks for your Help.

    Reg,
    CVishu

  6. #6
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Making a Excel File as Demo (ie Micros not to work after a certain days of 1st use)

    Sorry - in the VBE, select Tools / References / and the look for the file named Microsoft Visual Basic for Applications Extensibility 5.x and click the box next to it so that it is checked.

    VBA Extensibility.JPG

+ 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. Replies: 2
    Last Post: 09-08-2012, 10:51 AM
  2. Show File Pics Demo
    By united789 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-19-2011, 01:32 PM
  3. Making a Excel File Demo Version
    By ssghosal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2007, 12:45 PM
  4. making excel work like a mail merge
    By tjb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2005, 06:15 PM
  5. Replies: 1
    Last Post: 04-20-2005, 02:06 PM

Tags for this Thread

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