Set Document Focus to Top of Datasheet
 

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

Set Document Focus to Top of Datasheet
 

Aine,

Put this in 'ThisWorkbook':

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

--
Dan

Set Document Focus to Top of Datasheet
 

Set the workbook on open event to select sheets("sheetname").cells(1,1)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

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