C,
I think this varies with your video adapter, but here's what I do. I have
a Radeon 7500 adapter. You might check for settings in your adapter that
might bear on this (Start - Control Panel - Display).
Excel won't maximize across both my monitors. So I leave Excel in a
window (not maximized), then stretch it across both monitors. Then I
leave the document windows inside Excel as windows, and adjust them to fit
each monitor. It's a bit of trouble, but with two large monitors, I'm
used to sizing and moving windows around a lot anyway. This is pretty
much what you'd do with a single monitor, except that you could leave
Excel maximized.
Alternately, I can run two instances of Excel (start a second with the
Start button). In that case, either will maximize to the nearest monitor.
Then I can run the document windows (one in each instance) maximized.
When working with VBA, it's handy to have the VBE in a separate monitor.
Then I can step through the code and watch all the wrong stuff that's
happening in the worksheet.
Earl Kiosterud
www.smokeylake.com