Seelcting specific sheet and cell on startup

[Yendorian]

I have an Excel workbook which has 5 worksheets. I would like to add some VBA
code so that whenever the workbook is opened, we automatically go to Sheet 3,
Cell F6. And in which category should I write this code - Sheet1, 2, 3, 4, or
5 or This Workbook?
Can anyone help please

 

[Gary''s Student]

In the workbook code area:

Private Sub Workbook_Open()
Sheets("Sheet3").Activate
Range("F3").Select
End Sub

 

[Kevin B]

Press Alt+F11 and insert the following code to the Workbook's Open event:

Private Sub Workbook_Open()

Sheets(3).Activate
Range("F6").Select

End Sub

 

[Yendorian]

Thanks very much for this! It works - of course!

In the workbook code area:

Private Sub Workbook_Open()
Sheets("Sheet3").Activate
Range("F3").Select
End Sub

 

[Yendorian]

Thanks very much for this; That's a great help.

Press Alt+F11 and insert the following code to the Workbook's Open event:

Private Sub Workbook_Open()

Sheets(3).Activate
Range("F6").Select

End Sub