Open last worksheet viewed

D

Don Pullem

When I open Excel I want it to display the last worksheet I worked on when I
previously closed it. How do I do that?

Don
 
B

bony_tony

If you save the file before you close it, it should automatically go
back to the last sheet you were on.
What version of Excel you using?

Tony
 
G

Gord Dibben

Don

Open Excel or open a workbook?

If a workbook, save the workbook with that worksheet active.

If open Excel to last workbook worked on, not so easy.

You could save to the desktop and open from there.


Gord Dibben MS Excel MVP
 
D

Don Pullem

Excel 2003.. My problem is that I created a new worksheet for 2007, I
entered some information and then saved it. When I open Excel later it
opens to a worksheet I used for my 2006 entries. I remember last year I had
this problem and someone on this forum told me how to get Excel to open to a
specific worksheet. Now I want Excel to display the 2007 worksheet when I
open it (Excel).

Don
 
O

orbii

put the code into ThisWorkbook in vb, i think that should do the trick. oh
replace "****" w/ what ever you named your sheet.

Private Sub Workbook_Open()
Sheets("Sheet2").Select
End Sub

aloha, orbii
 
D

Dave Peterson

Just to add to what Orbii wrote.

You may have existing code under the Workbook_Open procedure in the ThisWorkbook
module--or it could be in a General Module named Auto_Open.

If you find it in one spot, it's (probably) not in the other.
 
D

Dave Peterson

If your workbook is using Auto_Open, then it's probably not using
Workbook_Open. And vice versa.
 
D

Don Pullem

Sorry for delay in responding was away from my computer yesterday. I
finally found in my notes what I did last year to get the worksheet I wanted
at startup. I put the 2007 worksheet in the "XLSTART" folder under
Microsoft Office. Thanks for all your responses.

Don


orbii said:
oh oh oh, thank you so much... got to make a note to self on that one.
orbii
Click to expand...
 
Top