Event to set sheet and cell on open file

Cosmos75 · Apr 18th, 2002, 10:43 AM

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 · Apr 18th, 2002, 10:55 AM

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:



Sheets("Search").Activate

Activesheet.Range("A2").Select

HTH

Cosmos75 · Apr 18th, 2002, 03:21 PM

Thanks!! Works great!

Apr 18th, 2002, 10:55 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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: Sheets("Search").Activate Activesheet.Range("A2").Select HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 10:43 AM	#1
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	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?

Apr 18th, 2002, 03:21 PM	#3
Cosmos75 Board Regular Join Date: Feb 2002 Location: Tulsa, OK Posts: 354	Thanks!! Works great!