Lock a column depending on Date

  • Thread starter Thread starter Ian Ornstein
  • Start date Start date
I

Ian Ornstein

a familiar picture : Columns Headed Jan Feb Mar ....
The request is to neither recalc nor allow entry to the Feb column
cell in March or later in the year, not allow entry nor recalc to
cells in the Mar column in April or later.

I am soliciting suggestions for this task.

The solution could be worksheet functions or some vba code that looks
at the active cell, determines its column (and thereby month), calcs a
new value
or restores the existing value into the cell. In my first attempts at
this
approach, I had the calc code in the macro, not in the cell.

I suspect that the users would prefer to have their formulas visible
within the
formula bar so here again, I am asking for suggestions.

Thanks in Advance,
IanO
 
Hi Ian
one idea using data validation:
- select your range (e.g. January)
- goto 'Data - Validation' and choose 'Custom'
- enter the following formula
=MONTH(TODAY())<=1

for the February column
=MONTH(TODAY())<=2
and so on

This will prevent user entries though it will not prevent copy/paste
values into these cells but maybe this is sufficient for you
 
Back
Top