Look up Custom views
and Report manager.

I believe in excel 2003, you have to download the report manager

Excel's printing mechanism is weak, BUT the custom views allow you to define
multiple print ranges (even with different page orientations and hidden
columns)

The report manager lets you combine the views to print out together.

"excel-lent" wrote:


I'm using the ActiveWindow.SelectedSheets.PrintOut to print out sheets
that I select (i have three sheets). When i invoke the macro with any
combination of selected sheets it deselects the first two sheets and
only prints the third.

Any help with this one would be great. This forum has a-lot to offer,
but cant find the specifics.

Thanks in advance for your help.


--
excel-lent
------------------------------------------------------------------------
excel-lent's Profile: http://www.excelforum.com/member.php...o&userid=24298
View this thread: http://www.excelforum.com/showthread...hreadid=379037