K. Georgiadis
10-25-2007, 08:21 PM
I have a worksheet with two data sets (about 36 rows each), one below the other, each representing a different fundamental strategy of product development. Each data set has 4 combo boxes that control scenarios in four different business variables.
For a variety of reasons, the least complicated way to control which data set is used for further calculation is to hide the data set that does not apply through a toggle mechanism. This works fine except that all four combo boxes from the hidden range pile up on top of one another, like Lego blocks, and act as a distraction.
Is there any way to make the combo boxes also disappear temporarily or is this the nature of the beast?
For a variety of reasons, the least complicated way to control which data set is used for further calculation is to hide the data set that does not apply through a toggle mechanism. This works fine except that all four combo boxes from the hidden range pile up on top of one another, like Lego blocks, and act as a distraction.
Is there any way to make the combo boxes also disappear temporarily or is this the nature of the beast?