View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Martin Parker[_2_] Martin Parker[_2_] is offline
external usenet poster
 
Posts: 14
Default 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