+ Reply to Thread
Results 1 to 6 of 6

cell auto-lock after entering time

  1. #1
    Registered User
    Join Date
    09-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Lightbulb cell auto-lock after entering time

    Hi,

    I need some guidance . I'm not too bad with excel but I'm no expert either. I have created a time sheet and I would like to know if there is a way to auto-lock cells after time is entered so that it cannot be changed. As of right now I have employees enter the time by using Shift+Ctrl+;, so the exact time is recorded, however employees can write in whatever time they want. so I guess what I want to do is 2 things:

    1- can the cell be formatted to only accept Shift+Ctrl+;, so that the exact time is entered in the cell and prevent employees from entering times they were not at work? and
    2- can the cell auto-lock after Shift+Ctrl+; is entered so that they can't modify the time sheet the next day if they arrived earlier than the day before?

    I'm not sure if what I want to accomplish is doable.. please help and remember I’m no expert Below is the document i created. Thank you!!!!
    Timesheet.Test.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: cell auto-lock after entering time

    Timesheet.Test.xlsm

    Try this
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    09-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: cell auto-lock after entering time

    Simplicity indeed Thank you!!! like i said I'm no excel expert... it is definitely easier to click in and out of the cell but the time can still be modified after its entered... is there a way to prevent this or am I thinking of something that excel is not capable of doing? (I always think excel can do everything my brain can come up with )

  4. #4
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: cell auto-lock after entering time

    Timesheet.Test.xlsm

    no it's perfectly possible ...we can use worksheet protect ...
    The password is "passme"
    Last edited by AndyLitch; 09-17-2013 at 11:06 AM.

  5. #5
    Registered User
    Join Date
    09-16-2013
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: cell auto-lock after entering time

    thank you you are AWESOME!!!!

  6. #6
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: cell auto-lock after entering time

    Not awesome but glad to have helped

+ 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] Entering new Row in cell and it will Auto SUM
    By thursday140 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2013, 08:42 AM
  2. Replies: 0
    Last Post: 01-29-2013, 04:59 PM
  3. Auto Run Macro to fill and lock the date & Time
    By shaikh.2211 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2012, 02:49 AM
  4. How to auto lock a cell once data is entered
    By infonaurvind in forum Excel General
    Replies: 1
    Last Post: 06-08-2012, 06:57 AM
  5. Auto Sort, Auto Lock, Auto Date & Time Stamp
    By suehatesyou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2010, 02:57 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