Home |
Search |
Today's Posts |
#1
|
|||
|
|||
in a line of three possible answers how to prevent multiple answer
I am offering three possible answers to a question. I want to prevent
multiple answers to one question eg. when a cell has been filled I want the other cells to automatically block |
#2
|
|||
|
|||
You need a worksheet_change event macro. The logic would be something like
Look at all three cells If all three are empty, then unprotect all three. if any cell is not empty, then protect the other two and unprotect the non-empty cell. -- Gary''s Student "RichardZ" wrote: I am offering three possible answers to a question. I want to prevent multiple answers to one question eg. when a cell has been filled I want the other cells to automatically block |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
strange horizontal line showing accross several columns | Excel Discussion (Misc queries) | |||
Label an average line in a dynamic chart | Charts and Charting in Excel | |||
coloring overy other line without doing so line by line | Excel Worksheet Functions | |||
Line and Column Graph | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |