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
previously closed it. How do I do that?
Don
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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
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
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
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
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.
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.
O
orbii
Auto_Open.
aaah cool, thanks!
orbii
aaah cool, thanks!
sorry not quite sure what you mean...If you find it in one spot, it's (probably) not in the other.
orbii
D
Dave Peterson
If your workbook is using Auto_Open, then it's probably not using
Workbook_Open. And vice versa.
Workbook_Open. And vice versa.
O
orbii
oh oh oh, thank you so much... got to make a note to self on that one.
orbii
orbii
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
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
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.