Deselecting sheets after the PrintOut method
 

I'm using the PrintOut method for the Sheets collection object to print
a selected subset of sheets at once.

Sheets(Array("Chart A", "Chart B", "Sheet X", "Chart C")).PrintOut
Copies:=1, Collate:=True

They print just fine, but the sheets remain selected afterwards. How
can I deselect the sheets?

Thanks,
John

Deselecting sheets after the PrintOut method
 

Hi John

Sub test()
Dim x As String
x = ActiveSheet.Name
Sheets(Array("Chart A", "Chart B", "Sheet X", "Chart C")).Printout
Sheets(x).Select
End Sub

--


XL2003
Regards

William



wrote in message
oups.com...
I'm using the PrintOut method for the Sheets collection object to print
a selected subset of sheets at once.

Sheets(Array("Chart A", "Chart B", "Sheet X", "Chart C")).PrintOut
Copies:=1, Collate:=True

They print just fine, but the sheets remain selected afterwards. How
can I deselect the sheets?

Thanks,
John