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


On Oct 9, 3:25*am, Mas wrote:
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.