Hi all.
long time reader, first time poster.
I am looking for help on this one.
I have an excel sheet where data is entered on a monthly basis.
I want the rows to be locked if the date entered in column A for each row is older than the current month.
Therefore users will be able to enter new data into the columns for this month, but once the date moves to next month, all data from previous months will be password protected from editing.
(To summarise, I enter date in column A. Once that date is not the equal to the current month I need to protect the row)
long time reader, first time poster.
I am looking for help on this one.
I have an excel sheet where data is entered on a monthly basis.
I want the rows to be locked if the date entered in column A for each row is older than the current month.
Therefore users will be able to enter new data into the columns for this month, but once the date moves to next month, all data from previous months will be password protected from editing.
(To summarise, I enter date in column A. Once that date is not the equal to the current month I need to protect the row)
