One of our requirement is to lock the cell if there is no value in the next cell in the same row.
Cells A B C D
Row1 0 1
Here B1 is a readOnly/Locked cell and B1 value is set through a VLookUp formula.
We have to make
1. Cell A1 read only if Cell B1 has value 0 or Blank.
2. Display error message if A1.Value > B1.value.
This we have to apply in all the rows.
We have tried to write a VBA code using Taget.Cells.Next.Value to get B1 value. But unfortunately Taget.Cells.Next is pointing to the C1 cell ( ignoring B1 locked cell) instead.
Please suggest if there is any solution using ASPOSE to implement this scenario.