 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2007Open last worksheet viewed
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 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 > 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 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 > If you save the file before you close it, it should automatically go > back to the last sheet you were on. [quoted text clipped - 7 lines] >> >> Don 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 > 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 [quoted text clipped - 15 lines] >>> >>> Don 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. > 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 [quoted text clipped - 15 lines] > >> > >> Don  SignatureDave Peterson > Auto_Open. aaah cool, thanks! > If you find it in one spot, it's (probably) not in the other. sorry not quite sure what you mean... orbii > Just to add to what Orbii wrote. > [quoted text clipped - 25 lines] >> >> >> >> Don If your workbook is using Auto_Open, then it's probably not using Workbook_Open. And vice versa. > > Auto_Open. > aaah cool, thanks! [quoted text clipped - 37 lines] > > > > Dave Peterson SignatureDave Peterson oh oh oh, thank you so much... got to make a note to self on that one. orbii > If your workbook is using Auto_Open, then it's probably not using > Workbook_Open. And vice versa. [quoted text clipped - 45 lines] >> > >> > Dave Peterson 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 > oh oh oh, thank you so much... got to make a note to self on that one. > orbii [quoted text clipped - 51 lines] >>> > >>> > Dave Peterson 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 >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
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.