| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Open hidden sheets from a drop down list selection
I have a file with many hidden sheets eg Sheet1, Sheet2...Sheet50. What I
want is some code which looks at the selection from a drop down list (on a visible sheet) and the open that sheet. ie if I select Sheet5 from the drop down list, Sheet5 becomes visible. I then want to hide it again once I have finished with it (I can do that bit!). The reason I am doing this is because otherwise I will have too many sheets to tab through. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| Drop list affected by previous choice | Excel Worksheet Functions | |||
| Adding value to drop down list | Excel Discussion (Misc queries) | |||
| Problems with external references when creating a drop down list | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Threaded Mode
