Excel 2002

  • Thread starter Thread starter Trip Levert
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Always open on Worksheet1, A1 even if last saved elsewhere 2
Tracking Access in Read-Only Files 0
Excell 2021 0
Cannot copy worksheet to another file 2
Open .xlsx files in Excel 2002 2
Opening on a specific worksheet 2
IPhone sound quality gets worse each generation 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1

Back
Top