+ Reply to Thread
Results 1 to 2 of 2

Lock Cells after Date has Expired

  1. #1
    Registered User
    Join Date
    04-22-2015
    Location
    Swansea
    MS-Off Ver
    2007
    Posts
    1

    Lock Cells after Date has Expired

    Hello all, I have several spreadsheets that users fill in on a monthly basis. These are collated into on master document used as a report. an email goes out for users to complete the spreadsheets by the end of the month. The spreadsheets are password protected and all cells are locked other than the ones which information is required to be filled in.
    I would like to know how to only allow this months cells to be unlocked and as the months progress, to lock last months and unlock this months cell columns. This would stop users filling in months in advance and also highlight users that do not fill in the spreadsheets on time.
    On the example, January, February and March are filled in and need to be locked as the date has expired. April allows the user to enter data and May to December also needs to be locked. Can this be achieved without VB code and just in functions?

    Thanks
    Paul
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Lock Cells after Date has Expired

    Can this be achieved without VB code and just in functions?
    I'm going to say no. If it is possible I too want to know how.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. How to lock cells after a date has passed
    By QuintonMcCloud in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-17-2015, 03:40 AM
  2. Lock Cells after Specified Date
    By EMcK in forum Excel General
    Replies: 1
    Last Post: 08-27-2014, 03:20 AM
  3. Blinking/Flashing cells after Date has expired
    By xcalibardead in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-17-2012, 03:22 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 a certain time/date?
    By nettorrep22 in forum Excel General
    Replies: 0
    Last Post: 07-14-2010, 11:23 AM

Tags for this Thread

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