+ Reply to Thread
Results 1 to 6 of 6

Expiration date file

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    Suceava, Romania
    MS-Off Ver
    Excel 2007
    Posts
    4

    Expiration date file

    Hallo,

    I created a file which is valid up to a certain calandaristic date.Some of the users are using this file after this date by changing the date on the system. How can I put a protection linked to a calendar date, even users are changing manually the system date?

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Expiration date file

    Before releasing the file to the end user just keep a temp sheet.
    In Temp Sheet just store the Start Date in A1 cell and End Date in A2 Cell.
    Hide it with very hidden property of VBA window and lock the project with a password too...

    In Workbook_Open event compare whether A3 cell (In the initial Stage It will be blank cell) value is lower than the current system date if so then just store the current date of the sytem in A3 cell and allow the code to check the rest of the Start and End Date conditions.

    If A3 is greater than Current System Date then have a code to exit the file and write Exit in A3.

    So when next time workbook opens and find a value Exit in A3 then the code will simply exit the file instead of checking the rest of the parts.

    So the current date is assigned in A3 cell so changing the system time won't help the end users in this case


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    12-12-2013
    Location
    Suceava, Romania
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Expiration date file

    Hallo,

    Thank you for your quickly response. There is a problem. This file is like a template. This file is accessed each time the initial form (template), make an offer and then saved with "Save As" and name .....
    The next time you access the same file (template) which did not save anything about dates.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Expiration date file

    Sorry I don't have any other options with me

    I hope someone will pitch in and give solution for this issue

  5. #5
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Expiration date file

    Not fool proof but perhaps you may find something useful in this link.

    http://www.cpearson.com/Excel/workbooktimebomb.aspx

    Your best option would probably be to buy some 3de party software. Try googling for "doneex.com" price singel user ca 100 usd.

    Alf

  6. #6
    Registered User
    Join Date
    12-12-2013
    Location
    Suceava, Romania
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Expiration date file

    Thanks for your suggestion!

    I will try it and I'll give you a feed-back.

+ 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. Expiration Date
    By stevenchaplin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-23-2013, 03:56 PM
  2. [SOLVED] calculation of expiration date
    By deth in forum Excel General
    Replies: 8
    Last Post: 04-15-2012, 05:20 PM
  3. Year expiration date
    By kwriram in forum Excel General
    Replies: 3
    Last Post: 10-29-2008, 11:36 AM
  4. set expiration date
    By nhat8121 in forum Excel General
    Replies: 13
    Last Post: 01-05-2007, 10:02 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