Printing multiple sheets and KEEPING print settings

[Jeff P]

I am aware of the ability to select multiple sheets in
Excel 2000, choose file>page setup, and have the settings
apply to all selected sheets.

Here is my current problem:
I am selecting multiple sheets, some landscape and some
portrait, and when I print, all selected sheets inherit
the page setup of the last selected sheet. The proper
behavior should be for each tab to maintain its own
individual print settings unless I physically do a
file>page setup.

 

[Ron de Bruin]

Hi Jeff

You can use a macro for printing the selected sheets

Sub test()
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PrintOut
Next wkSht
End Sub

 

[Guest]

Ron

I appreciate your suggestion. My frustration is that I
shouldn't have to execute a macro to perform something
that Excel is supposed to do by default. I had my machine
updated by my desktop support a few weeks ago and I
suspicious that something in that may have caused this.

-----Original Message-----
Hi Jeff

You can use a macro for printing the selected sheets

Sub test()
Dim wkSht As Worksheet
For Each wkSht In ActiveWindow.SelectedSheets
wkSht.PrintOut
Next wkSht
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Jeff P" <[email protected]> wrote in

message news:[email protected]...