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