| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: I need a sheet to be opened based on a cell value
I have a dialog box that I am using to pull up a specific sheet in my
workbook. It has 2 option buttons, one for week 1 and one for week 2, then it has a dropdown for the day of the week. I then use the concatenate command to combine the day and the week in the ref cell. My question is... How do I get the sheet that the cell name is referenced to open when I click the OK button? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
| Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
| To fix a sheet in MS Office to be opened first always | Excel Worksheet Functions | |||
| Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
| Excel VBA (?!)-refer to a cell on Sheet to left of X, based on criteria on Sheet X | Excel Programming | |||
Linear Mode
