Printing using Option Buttons and Check Boxes

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

thanks for the reply pike.
I have used this method in the past to create print options but i cant see how this would involve using the option buttons.
Using this method i could record a macro make it portrait and A3 then assign that code to a command button, but then i'd need a command button for each possible combination of landscape/ portrait/ a3/ a4.
Unless i'm mistaken in assuming this?