+ Reply to Thread
Results 1 to 2 of 2

posted data in a range of cells can't change after three days

  1. #1
    andycapp
    Guest

    posted data in a range of cells can't change after three days

    I hav little or no knowledge of how to write vb ocde. But this is what I am
    trying to do: On friday say 03-10-06 data is posted in range B5:H5 and on
    friday 03-17-06 data is posted in range B6:H6, on the third day after
    entering data no changes can be made to that data. I am using excel 2002

  2. #2
    Mike Fogleman
    Guest

    Re: posted data in a range of cells can't change after three days

    Is this workbook shared on a network? If so, macros will not run. Does the
    workbook get entries week after week after week? If so, when does it end and
    a new one is started? Is there data adjacent to row 5 or in columns A and I
    that you would not want protected? In other words, in the Current Region of
    the entered data. Also keep in mind that any code that can be written can be
    altered by the user or just set the computer clock back in time and make the
    macro think it is a day before the cells are locked.

    Mike F
    "andycapp" <[email protected]> wrote in message
    news:[email protected]...
    >I hav little or no knowledge of how to write vb ocde. But this is what I am
    > trying to do: On friday say 03-10-06 data is posted in range B5:H5 and on
    > friday 03-17-06 data is posted in range B6:H6, on the third day after
    > entering data no changes can be made to that data. I am using excel 2002




+ 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