Excel 2002

T

Trip Levert

Is there a way to set an excel file to open to the same
worksheet regardless to where it was last saved?
 
C

Chip Pearson

Trip,

In the ThisWorkbook code module, put the following code. Change
"Sheet1" to the desired worksheet name.

Private Sub Workbook_Open()
Worksheets("Sheet1").Select
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top