This is a handy and simple bit of VB to stick on your Worksheet_Activate event.
When added to a worksheet’s code, it ensures that when the sheet is selected it opens scrolled to the top left. So if someone has scrolled along or down and saved the workbook, it will re-open set to the desired position.
ActiveWindow.ScrollRow = 1
ActiveWindow.ScrollColumn = 1