Set Document Focus to Top of Datasheet

[aine_canby]

When opening an excel doc, I'd like it alway to open with the top
portion of its datasheet visual. That is, the A1 cell should be
visible when the document opens. At the moment, it opens up to show
where in the document it was when it was last closed.



Thanks,

Aine

 

[Dan R.]

Aine,

Put this in 'ThisWorkbook':

Private Sub Workbook_Open()
ActiveSheet.Range("A1").Select
End Sub

 

[Guest]

Set the workbook on open event to select sheets("sheetname").cells(1,1)