+ Reply to Thread
Results 1 to 2 of 2

Prevent time manipulation

  1. #1
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Prevent time manipulation

    =YEAR(TODAY()) will result in 2016

    But is it possible to prevent the user to change this, when the user changes years on the Windows control panel?
    So if one adds 2 years in the Control Panel, formula above will still be 2016.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,421

    Re: Prevent time manipulation

    If you want the number fixed at 2016, then put that number in the cell rather than a formula.

    Hope this helps.

    Pete

+ 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] Time Manipulation
    By vichisov in forum Excel General
    Replies: 3
    Last Post: 04-15-2013, 11:25 AM
  2. [SOLVED] How to prevent user(s) reset PC time
    By tuongtu3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-19-2012, 01:21 AM
  3. Prevent excel from messing with time
    By si14 in forum Excel General
    Replies: 5
    Last Post: 05-30-2012, 04:40 AM
  4. Prevent two macros from running at the same time
    By Kreef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-31-2011, 10:36 PM
  5. time manipulation: 13:20 + 2:40 =???
    By xianwinwin in forum Excel General
    Replies: 3
    Last Post: 12-02-2006, 11:52 AM
  6. [SOLVED] String manipulation in macro runs slower each time ran.
    By Lamination Technology in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2006, 02:00 AM
  7. Replies: 2
    Last Post: 12-18-2005, 08:20 PM
  8. Excel Time Manipulation
    By BFiedler in forum Excel General
    Replies: 0
    Last Post: 09-14-2005, 08:15 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