Great said:
How do I make Excel 2003 open a new window for each spreadsheet / workbook I
open
There may be some confusion of terminology here.
Each instance of Excel can have a number of workbooks open
Each workbook that is open may have 1 or more windows visible
(or 0 if the workbook is hidden)
Such windows are listed on the Window menu
An instance of Excel can show on the taskbar each of the individual workbooks
it has open, or it can just have a single entry on the taskbar.
So, if you mean you want to see a separate button on the taskbar for each
workbook, set Tools > Options > View > Windows in Taskbar.
If you mean that you want Excel to create an additional window onto each
workbook that you open (so that if the workbook already has 2 windows open, a
third window will be opened), you would do ThisWorkbook.NewWindow in a
Workbook_Open procedure. But I think it unlikely you meant that.
If you mean that you want each new workbook that you open to appear on the
window menu, then that happens automatically.
If you mean that you want each workbook that you open to open in a new instance
of Excel, this can only apply to launching Excel from within another
application - e.g. double-clicking an XLS file in Windows Explorer.
You could cause this to happen from Windows Explorer > Tools > Folder Options >
File Types > XLS > Advanced > Open > Edit >
- uncheck Use DDE
- add "%1" to the end of the "application used..." box
Bill Manville
MVP - Microsoft Excel, Oxford, England
