Posted by Richard Spilky on January 13, 2001 7:26 PM
Let's say I have 21 worksheets in a workbook. The first worksheet is called "INPUT" and the rest are named "ONE", "TWO", "THREE", respectively up to "TWENTY". Depending upon a certain selection in a certain cell on the "INPUT" worksheet, say, 1, 2, 3, or 4 for example, I would like certain of those worksheets to be hidden or visable depending on which number is selected in this particular cell on the "INPUT" worksheet. For example, if "1" is selected, than worksheets ONE through FIVE would be visible and worksheets SIX through TWENTY would become hidden. If "2" is selected in this cell, than worksheets SIX through TEN would become visible and all the rest, (ONE through FIVE, and ELEVEN through TWENTY would become hidden, and so on.
Can this be done?
655 Bent Ridge Lane
Barrington, IL 60010