+ Reply to Thread
Results 1 to 2 of 2

Lock range of cells dependant on date range

  1. #1
    Registered User
    Join Date
    06-08-2007
    Posts
    22

    Lock range of cells dependant on date range

    I think the code discussed in here is getting me close, but I'm having trouble figuring out how to adapt it to my needs.

    Please Login or Register  to view this content.
    In my spreadsheet, I have the days of the week (Moday-Sunday) in A3:G3

    This spreadsheet is used every week, with the start date (in the case of this week, 1/14/08) in cell A1.

    I don't want the data in the columns changed unless that column is todays date or earlier (so data in the Saturday column (F:F) can't be modified on Friday, but it could be on Saturday or Sunday).

    How do I get this to loop properly?
    Last edited by VBA Noob; 01-18-2008 at 07:36 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello stir-crazy,

    If I understand your post correctly then this macro should do what you want.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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