Open a workbook in a specific sheet

[Emece]

How can I do this? For example, I want a workbook to open
in Sheet 2 every time I open it.

Thanks!

 

[Gord Dibben]

Emece

You can use VBA Workbook_Open code to go to the specific sheet.

Right-click on the Excel Icon at top-left corner of Menu Bar. Select "View
Code. Paste this code in there. Save the file.

Sub WorkBook_Open()
WorkSheets("Sheet2").Activate
End Sub

OR use Workbook_BeforeClose code to set the worksheet as the active sheet upon
closing the workbooK.

Note: with either of the above methods the code goes into the ThisWorkbook
module, not a general or worksheet module.

In a general module you would use Sub Autpen() or Sub Auto_Close()

Gord Dibben XL2002

 

[pfsardella]

You can do this using events. Here are a few WebSites that explain
events.

http://www.mvps.org/dmcritchie/excel/event.htm
http://www.cpearson.com/excel/events.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;213220&Product=xlw
http://support.microsoft.com/default.aspx?scid=kb;EN-US;291294
http://support.microsoft.com/default.aspx?scid=kb;EN-US;161761

You could use the Workbook_Open event.

Private Sub Workbook_Open()
Worksheets("Sheet2").Activate
End Sub

If you're not familiar with using macros,

http://www.mvps.org/dmcritchie/excel/getstarted.htm

HTH
Paul