Always open on Worksheet1, A1 even if last saved elsewhere

  • Thread starter Thread starter B. Orr
  • Start date Start date
B

B. Orr

Is there a general setting to always reopen on the first worksheet,
regardless of where you were in the file when last saved?
 
Hi,

there's no setting but you can use the workbook open event. ALT+F11 to open
VB editor. Double click 'ThisWorkbook' and paste the code belwo in on the
right

Private Sub Workbook_Open()
Sheets(1).Activate
End Sub

Mike
 
hi
a workbook_open macro would work
Private Sub Workbook_Open()
Sheets("sheet1").Activate
Range("A1").Activate
End Sub

Regards
FSt1
 
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

How do I make worksheet2 = to worksheet1? 2
SumIf with multiple Criteria 6
Bring focus to same cell every time opened?? 2
I need a Formula for a Database 3
autocalculate doesn't work even with formula . 1
Excel opening cell 2
Open a excel workbook always on the same sheet 1
The Last of Us - Part I (PC) 6

Back
Top