Hello,
By having a column (column A) unlocked on a protected sheet the
user can type a value (1,2,3 etc) and the corresponding cell on
column B should give the static time. Although i can do it on an
unprotected sheet VB returns an error when it is protected which
is natural since the column B which the script updates with the
static time is locked. Is there a possiblity to unlock the cell from
column B just after the user entered a valid data in the cell of
column A, write automatically the static time (.value = Now /
.entireColumn.Autofit) and then re-lock the cell of column B so
the user cannot change the value of the date and time?
Thanks in advance,
Nik