Hi gang,
Is it possible that once a cell has entered a correct value,for that to unlock to a certain cell.
for example:
A1= is empty
A2 = locked
A1 = "True" <---- Typed in "true", A2 becomes unlocked for user to fill in?
A2 = unlocked
J
Hi gang,
Is it possible that once a cell has entered a correct value,for that to unlock to a certain cell.
for example:
A1= is empty
A2 = locked
A1 = "True" <---- Typed in "true", A2 becomes unlocked for user to fill in?
A2 = unlocked
J
Good morning jodders
The only way you can do this without using VBA is through using data validation. Select cell A2, go to Data > Validation, select Custom, and enter this formula in the box :
=A1=TRUE
You may also want to make sure that the Ignore blanks box is not ticked. Set your input message and error alert accordingly.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Good afternoon Dom,
Many thanks for your help with this. I guess thats quite a good simple workaround for excel. Im going to try that for my next set of reports. Your help is much appreciated as always
Kind regards
J
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks