specify one excel sheet in an excel file to be active 1

[seaport]

How can I specify one excel sheet in an excel file (that has multiple sheets) to be active in the runtime when the excel file is opened? I mean assigning the active worksheet dynamically.

The ActiveSheet property of the excel workbook is read-only.

Thanks in advance.

Seaport

 

[dsi]

You can do this with VBA.
Go to the VB Editor
Select Insert>Module
Put this code into the module, changing the sheet name (in quotes) to suit your needs.

Sub Auto_Open()
    Sheets("Sheet1").Select
End Sub

The only downside to this is that you will be warned for macros when you open the file. You can turn off the macro virus protection to avoid this, but I would not recommend doing that.

 

[seaport]

Thanks dsi.

That's exactly what I need.

Seaport