+ Reply to Thread
Results 1 to 3 of 3

Expiration Date safe from changing computer's date

  1. #1
    Forum Contributor
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    200

    Expiration Date safe from changing computer's date

    Below is what I am using to protect my program I wrote but I know all they have to do is change the computer's date and it will work. Is there a way to protect from that?



    Please Login or Register  to view this content.
    Last edited by Leith Ross; 10-21-2014 at 05:30 PM. Reason: Fixed Code tags

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Expiration Date safe from changing computer's date

    You can write the date each time the workbook is opened to the bottom of a list on a hidden sheet. If the current date is less than the last date written, ...
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,369

    Re: Expiration Date safe from changing computer's date

    From a practical point of view, all they need to do is not enable macros. Then your workbook is open and exposed for forensic examination. Most Excel protection will only be effective against people with limited experience and awareness of Excel's capabilities.

    Do you have mechanisms in place such that the workbook is of no practical use unless macros are enabled? Is your VBA Project password protected and locked for viewing? Are the worksheets "very" hidden through the VBE interface, or just hidden, or not hidden at all?

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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: 08-09-2014, 12:40 PM
  2. Expiration Date
    By stevenchaplin in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-23-2013, 03:56 PM
  3. fixed date format in case computer has different date settings e.g dd/mm or mm/dd
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2013, 08:06 PM
  4. set expiration date
    By nhat8121 in forum Excel General
    Replies: 13
    Last Post: 01-05-2007, 10:02 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