How To Control Where Sheet Starts When You Open It?

[aedctalk]

Hi.

So right now i have nothing in my coulumn a but i am using it as a spacer to center my excel table.. However everytime i open the sheet it usually has column b on the very left of the page and column a is off the screen.

How can i make it so that column a is always on my screen at the left side?

I currently have D8 set as selected and activated and need that one to stay that way.

Thanks so much!

 

[Gary McMaster]

Maybe this?

Private Sub Workbook_Open()

ActiveWindow.ScrollIntoView Range("A1").Left, Range("A1").Top, 1, 1

End Sub