Try putting this code into the "ThisWorkbook" code

Private Sub Workbook_Open()
ThisWorkbook.Worksheets(1).Activate
ThisWorkbook.Worksheets(1).Range("A1").Select
End Sub

HTH,
Barb Reinhardt

"Elise148" wrote:

I posted something yesterday and the suggestions I got were good, but they
did not work. What I want to do is everytime a workbook is opened, have it be
opened to a certain place...A1 of the first sheet. I am not the one that will
be using this spreadsheet, I'm just designing it, and I know that the person
using it will not know to save it in A1 of the first sheet before closing
it...how would I go about doing this...go about programming it into VBA?

Thanks...