Always open on Worksheet1, A1 even if last saved elsewhere

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?
 
M

Mike H

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
 
F

FSt1

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

Regards
FSt1
 

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

Bring focus to same cell every time opened?? 2
Excel opening cell 2
autocalculate doesn't work even with formula . 1
Open a excel workbook always on the same sheet 1
Code to copy the last row formulas and paste it in the bottom row 3
Always open a workbook on Sheet1 regardless of sheet viewed when lastsaved 2
macro than refers to a cell? 1
Start up 1

Top