How to print multiple sections from different worksheets

[Mas]

Hi all,

I have two worksheets titled "Data" and "Report" in a workbook.

I would like to give the user an option either to print a section of the
"report" worksheet i.e. A1 to G10 which includes a table of text and a
chart or to print the data (A1 to C10) from the data worksheet or the
user can print both of the two options.

I hope someone can help me with this one as it would make my workbook
look so much cleaner and simpler for the user.

Thanks in advance.

 

[Don Guillett]

Try this macro assigned to a button/or printer shape
Sub doyouwanttopring()
ans1 = MsgBox("Do you want to print this", vbYesNo)
ans2 = MsgBox("Do you want to print this two", vbYesNo)
If ans1 = vbYes Then Sheets("report").Range("a1:g10").prinout
If ans2 = vbYes Then Sheets("data").Range ("a1:c10")
End Sub