Ok,
I thought of something but it will not work. I entered the following
code in the BeforePrint event to select all worksheets. The thought
being that once all work sheets are selected even if the user prints
selected sheets it will print all of them. It will not work. WHy?
My code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheets(Array("Sheet3", "Sheet2", "Sheet1", "Page 1")).Select
Sheets("Page 1").Activate
End Sub
--
retseort
------------------------------------------------------------------------
retseort's Profile:
http://www.excelforum.com/member.php...o&userid=24690
View this thread:
http://www.excelforum.com/showthread...hreadid=479968