Auto scroll Excel sheet to the top left

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

1 Comment on “Auto scroll Excel sheet to the top left

Leave a Reply

Your email address will not be published. Required fields are marked *