Hi guys,

I have a workbook with several worksheets - 1 of which is a control sheet that has options for the user to print.

I have 4 option boxes -
1) A4
2) A3
3) Landscape
4) Portrait
and 1 check box
1) Text Wrap
and 1 command button to Print using the selected options

I need a macro that looks at the whether these option boxes are ticked or un-ticked and makes the appropriate changes to all worksheets besides the worksheet that the option buttons/ boxes are contained on - sheet name "Welcome"

Regards