K
Keith R
I have a workbook that allows a user to put in monthly scores (one score per
month) that is plotted on a graph.
I have added another series so the user can input "projections" of future
performance.
After a month has started, the user should be allowed to change "future"
projections (next month and later) but no longer edit this month's (or
previous month's) projections. The end users will be maintaining the
workbook, so I won't be able to go lock new cells each month in everyone's
workbooks.
I can put the now() value in a hidden sheet, and I can write the formulas to
check if a cell /should/ be editable or not- but is there any way to use
that information to conditionally lock a cell in XL XP? The protection tab
is not available in the conditional formatting dialog.
I'm looking for a non-VBA solution because the combination of our IT
infrastructure and prior user training means that VBA stuff always requires
more work to get people to lower the security level, enable macros, etc.
TIA,
Keith R
month) that is plotted on a graph.
I have added another series so the user can input "projections" of future
performance.
After a month has started, the user should be allowed to change "future"
projections (next month and later) but no longer edit this month's (or
previous month's) projections. The end users will be maintaining the
workbook, so I won't be able to go lock new cells each month in everyone's
workbooks.
I can put the now() value in a hidden sheet, and I can write the formulas to
check if a cell /should/ be editable or not- but is there any way to use
that information to conditionally lock a cell in XL XP? The protection tab
is not available in the conditional formatting dialog.
I'm looking for a non-VBA solution because the combination of our IT
infrastructure and prior user training means that VBA stuff always requires
more work to get people to lower the security level, enable macros, etc.
TIA,
Keith R