How to open a specific worksheet via code from workbook_open

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
 
M

Martin Parker

Martin Parker said:
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

managed to solved this one myself!!

Worksheets(Worksheets("sheet1").Range("c5").Value).Activate

Is this the best way of doing this??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top