Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a combobox which is populated with all the worksheets within the
workbook. The controlsource of the combobox is linked to a cell on a worksheet. My question is how do i make the Excel workbook open at the worksheet which is detailed within the combobox linked cell. I've been previously using in the Workbook_Open procedu- Worksheets("Sheet1").activate but how do i incorporate the linked cell reference to open the worksheet the user has chosen via the combobox. Hope you can help! Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to open Notes database and find a specific doc | Excel Programming | |||
Open Specific Worksheet | Excel Discussion (Misc queries) | |||
Open on specific worksheet | Excel Discussion (Misc queries) | |||
VB code to make Excel open in a specific worksheet | Excel Programming | |||
VBA code to open a specific worksheet | Excel Programming |