Event to set sheet and cell on open file

[Cosmos75]

I have a workbook with a few sheets.

I want the workbook upon opening the file to go to a particular sheet and a particular cell on that sheet.

Sheet name = "Search"
Cell = A2

How do I do this with with an Excel Event?

 

[Mark O'Brien]

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

 

[Cosmos75]

Thanks!! Works great!