Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting no of days of a specific range of days from a list | Excel Discussion (Misc queries) | |||
How do I add numbers in a range of data from days of the week? | Excel Worksheet Functions | |||
Color shading on cells posted 11/5/2008 ans. by Mr. Johnc | New Users to Excel | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions | |||
Posted date in a range of cells that can't be edited after three d | Excel Programming |