option buttons or check boxes

I am fairly new to VBA and trying to learn on the fly. I have a spreadsheet
with 4 sheets, each with its own name. I want to create 4 check boxes or
option buttons on the first sheet. I have print button. I want to have it
so when you check a box and hit the print button, only that sheet will print.
If you check all 4, all 4 print, etc.

Can anyone help?

Thanks!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200608/1

meandmyindigo via OfficeKB.com wrote:
> I am fairly new to VBA and trying to learn on the fly. I have a
> spreadsheet with 4 sheets, each with its own name. I want to create
> 4 check boxes or option buttons on the first sheet. I have print
> button. I want to have it so when you check a box and hit the print
> button, only that sheet will print. If you check all 4, all 4 print,
> etc.
>
> Can anyone help?
>
> Thanks!


Maybe this suggestion from John Walkenbach's site would be useful for you:

http://www.j-walk.com/ss/excel/tips/tip48.htm

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Franz Verga wrote:
>> I am fairly new to VBA and trying to learn on the fly. I have a
>> spreadsheet with 4 sheets, each with its own name. I want to create
>[quoted text clipped - 6 lines]
>>
>> Thanks!
>
>Maybe this suggestion from John Walkenbach's site would be useful for you:
>
>http://www.j-walk.com/ss/excel/tips/tip48.htm
>
Thank you. I will check it out.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200608/1