i have a workbook with 20 sheets, each one bringing forward information from
previous sheet. i want to allow data entry into a cell if it has no value
brought forward. each cell in the column range has a formula linking it to
the corresponding range in the previous month's sheet, but not all cells will
contain data. once the data, if any exists, is brought forward, there is a
possibility of data entry into the remaining cells in the column, which will
then be carried on to the next months sheet, and so on. on activating the
sheet, i want to scan the relevant cells and determine if there is
information there, and if so they will remain locked, but if a zero value is
present, unlock them.

still waiting for help here. i know this is a simple task, if someone will
suggest syntax for locking/unlocking cells and also ForEach... in Range()
syntax.

"david s." wrote:

i have a workbook with 20 sheets, each one bringing forward information from
previous sheet. i want to allow data entry into a cell if it has no value
brought forward. each cell in the column range has a formula linking it to
the corresponding range in the previous month's sheet, but not all cells will
contain data. once the data, if any exists, is brought forward, there is a
possibility of data entry into the remaining cells in the column, which will
then be carried on to the next months sheet, and so on. on activating the
sheet, i want to scan the relevant cells and determine if there is
information there, and if so they will remain locked, but if a zero value is
present, unlock them.