M
Martin Parker
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 procedure:-
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
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 procedure:-
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