Ensure A1 is always selected when opening Workbooks (possible safety feature)
In a standard module.

Sub Auto_Open()
 ActiveWorkbook.Sheets("Sheet1").Range("A1").Select
End Sub

or in ThisWorkbook

Private Sub Workbook_Open()
 ActiveWorkbook.Sheets("Sheet1").Range("A1").Select
End Sub


© Copyright andrewsexceltips.net All Rights Reserved.