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 cell c5 on Sheet1 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(Worksheets("sheet1").Range("c5").Value) but the above code doesnt seem to work. Hope you can help! Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to open a specific worksheet via code from workbook_open | 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 |