Starting excel'02 so that menu one left side showing (Opening a work, etc)
It sounds like you're describing the Task Pane. The Startup Task Pane
setting is in Tools>Options, on the View Tab.
But, if you have recorded a macro, a workbook may open automatically as
Excel starts up (e.g. Personal.xls). In this case, the Task Pane closes,
despite the Task Pane setting.
You can force it to stay open by making a change to the Registry.
To change the Registry (make a backup first!):
1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open Software, Microsoft, Office, 10.0, Common, and click on General
5. Choose Edit>New>DWORD Value
6. Type the name for the DWORD: DoNotDismissFileNewTaskPane
7. Press Enter to complete the renaming
8. Choose Edit>Modify
9. Type 1 as the value and click OK
10. Close the Registry Editor
Quote:
> I am using Excel02 and wanted to know how to change startup to show the the
> full left sided menu showing most recently opened files, "Opening a
> Workbook", "New...". For reason excel used to open with this option, but
> now it opens with a new file called Book1. Regards Tracy
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html