Results 1 to 8 of 8

Locking cells when today's date is passed.

Threaded View

Amir AbdRabu Locking cells when today's... 03-27-2014, 06:56 PM
Richard Buttrey Re: Locking cells when... 03-27-2014, 09:28 PM
Amir AbdRabu Re: Locking cells when... 03-28-2014, 07:02 AM
Richard Buttrey Re: Locking cells when... 03-28-2014, 01:20 PM
Amir AbdRabu Re: Locking cells when... 03-28-2014, 01:59 PM
Amir AbdRabu Re: Locking cells when... 03-28-2014, 11:19 AM
Amir AbdRabu Re: Locking cells when... 03-28-2014, 03:57 PM
Amir AbdRabu Re: Locking cells when... 03-29-2014, 09:09 AM
  1. #5
    Registered User
    Join Date
    03-27-2014
    Location
    Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Locking cells when today's date is passed.

    Hello,
    Thanks for you fast response.
    I attached the sheet once more with two rows filled in it.
    As you will see, there is a column named (Entry Date). This column run with a VBA code that generates the date automatically when all the corresponding columns are filled from (A5:M5). SO when the row 5 (For example) is filled with data, the code automatically generates with the entry date and remains the same even if the user closed and opened the sheet at any other date. Its not a "today()" function....
    In that case, the entry date in rows 5 & 6 is 28/3/2014 because I entered the data today.
    What I need to do is, when the user tries to edit those data after 28/3/2014, he receives an error message and the code prevents him from editing this data and at the same time the user has the option to write new data in other rows following those rows starting row 7.
    I hope this is clear for you and I hope if you can respond to me with a code as soon as possible.
    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lock cells after Today's date passed (VBA excel code)
    By rt1306 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 05-16-2013, 12:06 PM
  2. I need to lock cells after date has passed on time shees.
    By Backsurge in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-20-2013, 01:24 AM
  3. Replies: 6
    Last Post: 08-23-2012, 12:14 PM
  4. Lock cells after today date passed
    By Abdul Haneef in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-13-2012, 07:17 AM
  5. Lock cells after Today's date passed (VBA excel code)
    By rt1306 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2009, 01:59 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