Hi Super Excel users
I have a pretty straight forward question.
Is it possible to lock cells dependent of which option bottoms being pushed by the user?
Example:
I have three option bottoms:
optionBottom_1, optionBottom_2, optionBottom_3
And I have three input cells where two should be open for inputs depending on the choice of the option bottoms.
Example:
If optionBottom_1 is pushed then a1 and b1 should be open for inputs and c1 should be locked for inputs.
Likewise if optionBottom_2 is pushed by the user, a1 and c1 should be open for inputs and b1 locked for inputs.
Hope someone can help me out here.
Regards
NCO
Denmark
I have a pretty straight forward question.
Is it possible to lock cells dependent of which option bottoms being pushed by the user?
Example:
I have three option bottoms:
optionBottom_1, optionBottom_2, optionBottom_3
And I have three input cells where two should be open for inputs depending on the choice of the option bottoms.
Example:
If optionBottom_1 is pushed then a1 and b1 should be open for inputs and c1 should be locked for inputs.
Likewise if optionBottom_2 is pushed by the user, a1 and c1 should be open for inputs and b1 locked for inputs.
Hope someone can help me out here.
Regards
NCO
Denmark