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.

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.