Startup

[katy]

Hi, is there a place in excel where I can set the default start up page to
'my last used worksheet' instead of a blank worksheet? About a month ago,
my Excel from Office 2007 did open to my last used worksheet, now it opens
to a blank one. I never changed anything and no one else uses this
computer. I believe an update made this change but I cannot be sure. I'd
just want to change it back to my last used worksheet.

TIA for any ideas...........katy

 

[Gord Dibben]

You cannot open a "worksheet".

You can open a "Workbook"

A workbook will open with the worksheet that was active when you saved the
workbook.

Excel will not open your last used workbook unless you have a shortcut to
that workbook.

To prevent a blank new workbook from opening appens a /e to your Excel
command line.

"C:\yourpath to Excel\Excel.exe" /e

Note the space before the backslash.


Gord Dibben MS Excel MVP

 

[katy]

Thank you GD.... when you said > A workbook will open with the worksheet
that was active when you saved the

workbook.... I tried exiting Excel with the worksheet I had open, but when
I go back to open it via my Quick Launch shortcut, it opens

with a blank worksheet again. How do I put a shortcut to my excel workbook
at the worksheet that I want to open with and put that shortcut on my quick
launch?
In properties of my quick launch icon, the target is Microsoft Office
Enterprise 2007 so there is no path or command line to change as you
indicated below.

TIA, katy

 

[Gord Dibben]

Your Quick Launch shortcut does not point to any workbook, just starts Excel
with a blank workbook.

You can change the command on your Quick Launch shortcut as I showed you
so's no blank book will open or you can open a specific workbook through
that same command line.

Command line to open a specific workbook.

"C:\yourpath\bookname.xls"

In order to always open at a particular sheet in that workbook you must use
VBA. In Thisworkbook module enter this code.

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


Gord