Setting up a print menu option button

New to VBA so this may be a bit of a complex question

I have a workbook with many workseets (about 27) that users may want to print the full report (all worksheets) or just selected worksheets.

Can anyone suggest a user friendly way of doing this other than selecting/grouping the sheets then print active sheets.

Ideally it would be cool to create a "Print" command button that created a list of all worksheets with an option button (like on the control toolbar) where the text for the each button was the name of a worksheet. The user would click on the ones to be printed, or a "print all" button. The 27 worksheets keep the same name, but some additional worksheets may be added from time to time, so the list need to be dynamic.

Any suggestions would be appreciated.

This is a userform that allows you to select which sheets to print or preview. It is part of my Worksheet Manager addin

That Is Awesome!!!!!


Ok, I'm trying to play with this and I'm having problems figuring out if there is a way to exclude (or include depending how you look at it) certain worksheets? Reason being, I have a lot of worksheets but the general user is only aware of a few of them so those are the only ones I'd like to show up in your form. I have the user viewable worksheets all color coded the same color as well so I'm not sure if that could be used as the 'if' condition in the code??

Any help on this would be greatly appreciated!