+ Reply to Thread
Results 1 to 3 of 3

protect cell after 1 day

  1. #1
    Registered User
    Join Date
    04-04-2016
    Location
    us
    MS-Off Ver
    2016
    Posts
    2

    Lightbulb protect cell after 1 day

    how lock specific cells after data has been added after 1 day?
    please help me out

    Thanks & Regards.

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: protect cell after 1 day

    Can you give an example or share a sample sheet displaying what needs to be locked & what should not..
    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Registered User
    Join Date
    04-04-2016
    Location
    us
    MS-Off Ver
    2016
    Posts
    2

    Re: protect cell after 1 day

    thank you for your quick response, i tried to attach the file but unfortunately is not possible.
    I send you a capture from file.
    This is a monthly timesheet for my employee. I want the column "In","Pause" and "Out" been locked after 1 day
    other columns is protected with exceptions Functie,Praktijk and Opmerking
    1.JPG
    Last edited by kody; 04-05-2016 at 07:09 AM.

+ 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] Protect Cell from User Edit Based on Cell Interior Color
    By MICowboy13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2015, 04:52 PM
  2. Excel 2013 - Protect Range of Cells without using Protect Sheet Button
    By caf20012 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-23-2014, 04:50 AM
  3. Replies: 2
    Last Post: 01-17-2013, 08:39 AM
  4. Lock/Protect another cell / a range of cells for specific value of one cell
    By ohlalayeah in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-04-2012, 04:25 AM
  5. Replies: 0
    Last Post: 07-03-2012, 05:42 AM
  6. [SOLVED] Passwords Disappear in OpenOffice (Protect Worksheet, and Protect Workbook)
    By msnews.microsoft.com in forum Excel General
    Replies: 6
    Last Post: 12-27-2005, 04:20 AM
  7. Replies: 2
    Last Post: 07-16-2005, 11:05 AM

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