How to open Excel 2013 on a specific sheet and cell.

[Legacy 380211]

Hello,

I'm very new when it comes to excel and the macro coding for it through VBA. I would like a basic macro that will allow the document I use to take me directly to a specific cell on a specific sheet each time I open it. Even if I save the document on a different sheet and cell. The sheet is Sheet1, and the cell is D5.

Any help would be most appreciated.
Thank you.

 

[sericom]

Add this to your workbook code

Private Sub Workbook_Open()
     Application.Goto Sheets("Sheet1").Range("D5")
End Sub