[RESOLVED] sheet opening

[pandey_om]

hi expert
i have a workbook PI-Template ,in which there are 3 sheets like sheet1,sheet2,sheet3
i coded
workbook_open()
worksheets("sheet1").activate
end

when i open the workbook sheet1 ativated on screen
the problem is that when i copy the same workbook with different name in another folder and when i open workbook ,sheet2 activated,
How i solve this problem

[Static]

worksheets(1).activate
will always select the first sheet no matter what the sheet name is

[pandey_om]

i copied the workbook with different name, not changing the worksheet name

[RobDog888]

Can you post more of your code?

[cssriraman]

Hi,

The Workbook_Open procedure MUST reside in the private module of the Workbook Object (ThisWorkbook).

Open the VBE double click the Module called ThisWorkbook, seen in the Project Explorer (View>Project Explorer (Ctrl+R)).

Private Sub Workbook_Open()
    Worksheets("sheet1").Activate
End Sub

The sheet name should match with the name which you gave in your code. if not you will get an error saying: "Runtime error '9'; Subscript out of range".

[pandey_om]

thanks experts my problem solved