+ Reply to Thread
Results 1 to 3 of 3

Lock a cell when a certain date in the month happens

  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2007
    Posts
    6

    Lock a cell when a certain date in the month happens

    What is a good formula or macro to lock a range (ranges) of cells after a certain date hits? And then also protect the worksheet (within the same macro)? You should note that the worksheet is presently protected (just the one sheet from the entire workbook). The password is just hitting enter (for now anyway).

    For example, I would like for this to happen exactly 10 days before the end of a month. The cells in question all have a date that equate to the end of a particular month. So a cell that needs to be locked would contain 1/31/14, 2/28/14, 3/31/14, etc. For January, I would like it to lock if it is 1/22/14 or later, February if it's 2/19/14 or later, etc.

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Lock a cell when a certain date in the month happens

    It would be greate if you provide sample workbook
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    Registered User
    Join Date
    01-17-2014
    Location
    St. Louis, MO
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Lock a cell when a certain date in the month happens

    Gotta get the data from work. In the mean time, open to suggestions.

+ 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. Replies: 4
    Last Post: 05-01-2013, 07:38 PM
  2. Populate cell with current date and time, then lock cell
    By panny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2012, 06:13 PM
  3. Replies: 5
    Last Post: 10-04-2012, 07:06 AM
  4. Lock Cell Date Format NOT Content
    By mlmaclean in forum Excel General
    Replies: 4
    Last Post: 12-30-2010, 08:00 AM
  5. Insert date then lock cell!
    By mevetts in forum Excel General
    Replies: 4
    Last Post: 12-21-2005, 06: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