Closed Thread
Results 1 to 3 of 3

Locking certain cells after a set time.

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Ohio
    MS-Off Ver
    2013
    Posts
    5

    Locking certain cells after a set time.

    Hi every one,
    I'm fairly new to excel and am pretty much self taught and learning as i go, I've got a sheet i use at work to track multiple people's productivity and have ran into an issue where people are going back and changing numbers for hours previous and was wondering if there is any way to format the cells to lock after a specified time? Thanks in advance for any help.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: Locking certain cells after a set time.

    Hi and welcome to the forum

    Short of password protecting the workbook (and then they wont be able to save any chsanges they make), you will only be able to do what you want using VBA
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,969

    Re: Locking certain cells after a set time.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-prog...-set-time.html


    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Locking specific cells eventually changing to locking all cells
    By davidingilbert in forum Excel General
    Replies: 1
    Last Post: 03-19-2013, 06:50 PM
  2. Help with macro, automatical locking cells when excel is closed but only locking 1 sh
    By snoopy1461 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2011, 11:29 AM
  3. Locking In Time
    By Dexta_Dark in forum Excel General
    Replies: 2
    Last Post: 05-06-2010, 04:53 PM
  4. [SOLVED] locking formula in cells in without locking whole sheet
    By SuziQ in forum Excel General
    Replies: 1
    Last Post: 07-21-2006, 11:05 AM
  5. Replies: 2
    Last Post: 09-10-2005, 01:05 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