Workbook_Open() & Workbook_Close()

Post date: Feb 3, 2011 11:26:05 PM

insert the vba in ThisWorkbook

Private Sub Workbook_Open()

Sheets("home").Select

Range("a1").Select

End Sub

Private Sub Workbook_Close()

Sheets("home").Select

Range("a1").Select

End Sub