open to a specific worksheet in a workbook

[dismas]

Is there a simple way to open a workbook to a specific worksheet?

Thanks,
Disma

 

[Bob Phillips]

Private Sub Workbook_Open()
ThisWorkbok.Worksheets("mySheet").ACtivate
End Sub

This code should go in the ThisWorkbook code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[dismas]

Thanks for your quick help.

Let me explain a little better what I am looking for.

I have a workbook with 30 worksheets in it.
I need to be able to open it from a web link using the same file, bu
each link able to open to a specific worksheet.

Is there a way to open a saved workbook by adding a suffix to th
specific worksheet.

I have tried several things but none work. Here are some examples tha
may clarify what I am asking.

The saved file is workbook.xls

workbook.xls#sheet4
workbook.xls!sheet 6

Hope that explains it better.

Thanks,
Disma