How to open a specific worksheet via code from workbook_open
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
|