XL2003 Opens new window

[MeGustaXL]

Is there a way to use the solution provided in thread68-1532588 to cause XL2003 to open new spreadsheets in a new window?

Chris

Someday I'll know what I'm donig...damn!

 

[xwb]

Not sure what you mean. If I double click on an excel sheet, it pops up. If I double click another sheeet, I get a second window.

If from the first window, I open another sheet then it appears in the same window.

If it doesn't happen then maybe you need the Steven Du modification to your OS.

 

[MeGustaXL]

Hi xwb, and thanks for your help

I'm using 2 monitors, so I want to have a workbook open in one screen, and another workbook open in the other screen, or display two worksheets from the same workbook, one on each display, at the same time so I can drag-and-drop from one to the other.

The double-click sheets thing didn't work for me - I'm using Office 2003, so is this even possible?

Chris

Someday I'll know what I'm donig...damn!

 

[xwb]

Open your worksheet. Click on new window. You now have two copies of the same worksheet. Try Window/arrange/tiled/vertical. See if that gives you what you are after. It may appear in the same parent window but that can be stretched over two or more screens.

 

[MeGustaXL]

That doesn't work for me because I have my screens set up as separate displays. So when I stretch the Excel window across both, it snaps back to fill only one of them.

The only way I can do it is to open Excel, open Workbook A, then open another instance of Excel and open Workbook B in it. I can then drag and drop cells from A to B and vice versa

The thread in the OP: thread68-1532588 gives this function each time you open a new workbook, ie it opens a new, separate window.

Chris

Someday I'll know what I'm donig...damn!

 

[xwb]

Are you on full screen or windowed? It shouldn't snap back if it is windowed: only if it is full screen.

Have you done the DDE change?