I have 4 sheets for the weeks of the month. I want to create a separate sheet
and show a list drop down box that when selected the appropriate sheet will
open up. I plan on hiding the sheets so the user will just see the beginning
sheet. Or maybe this should be handled by a form? Many thanks for kicking me
in the right direction.


Bruce

Since at least one sheet in a workbook must remain visible, you might as well
just build a list (Data | Validation) and type in the names of the other
sheets as the list to use.

Then I'd use that worksheet's _Change() event to detect a change in the
selection in that cell and based on the choice, make the chosen sheet the
visible one and select it to put it "in their face". Then on the other
sheets you could use the worksheet_deactivate() even to put them back into
hidden state when they click on the 'menu' sheet. I'd use the xlVeryHidden
value to set their visible property to, since that will keep them from even
showing up in the Format | Sheets [Unhide] list.

You can download a working example of all of that from he
http://www.jlathamsite.com/uploads/PickAWeek.xls


"BLD" wrote:

I have 4 sheets for the weeks of the month. I want to create a separate sheet
and show a list drop down box that when selected the appropriate sheet will
open up. I plan on hiding the sheets so the user will just see the beginning
sheet. Or maybe this should be handled by a form? Many thanks for kicking me
in the right direction.


Bruce