Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Hello, I need to have a workbook that would show a tab/sheet named "Main
Menu". I would also have 5 other tabs/sheets named after employees names and these sheets I need to be visible = false. What I wanted to do was to have a combo box on my "Main Menu" tab/sheet that would have all the names of the tabs/sheets that are curently visable = fale and when I select an tab/sheet from the combo box I would like it to make that tab/sheet visible = true and when I close the sheet it changes it back to visible = false. How can I do this? Thanks! I want to have a main tab that I would select an employees name from a drop down list "The employee name would be the name of a tab" Then it would make the tab visible then I would have a button to close or make it visible = false again and only show the main screen where I need to select an employee. How would I acomplish this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Row Selection using Drop down/Combo boxes | Excel Discussion (Misc queries) | |||
Combo box disappears after selection made | Excel Discussion (Misc queries) | |||
multiple selection in combo box | Excel Discussion (Misc queries) | |||
How do I keep the top row of a spread sheet visable? | Excel Worksheet Functions | |||
Combo Box selection to place $0 into another cell | Excel Discussion (Misc queries) |