Hi Alberto!
I don't think that there are any easy ways but you can make life
difficult.
You could use conditional format:
Formula Is:
=DATE(2003,12,30)+14<TODAY()
Format the font color the same as the background color.
Don't forget to use:
Format > Cells > Protection
Check Hide
OK
Tools > Protection > Protect Sheet
Give and confirm password.
It's not foolproof because you can see the data if you select the
block of cells 1 before to 1 after. Also there's nothing to stop using
a formula to return the value of 1 of the hidden cells.
You could put the data to be hidden on another sheet and reference
that sheet with those references being conditionally formatted. The
time locked data sheet could then be hidden and you can use Tools >
Protection > Protect Workbook to prevent unhiding the sheet. This way,
they might see the cell references but not the value.
As far as formulas referring to hidden cells is concerned, you really
stuck unless the entire workbook is locked. But they have to know
which cells are hidden...
But worksheet and workbook protection is not that difficult to
circumvent with freely available workbooks and / or code.
And of course, if they backdate the system date....
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
