1. Open the VBE (ALT+F11)
2. Double click on "ThisWorkbook"
3. In the edit window, click on the drop down on the left hand side and select "Workbook". (The code for the Workbook Open Event will appear)
Stick in this code:
<pre>
Sheets("Search").Activate
Activesheet.Range("A2").Select</pre>
HTH