VBA to print user selectable worksheets

[hilton426]

Good Morning, Excel Forum

I would like to add a button to a workbook which gives users to options of which sheets to print.
I feel that I'm halfway there but my basic (self taught) understanding of VBA is hindering me from moving forwards and understanding exactly how I can correct my errors!

Rather than giving the user the option of printing all sheets containing data I would only like to give them the option of printing visible sheets.
Is this possible?
I've attached a sample.

Thank you for reading & I appreciate your help
Laura

[cytop]

Do a simple check in the userform Initialize event that the sheet is visible...

Please Login or Register  to view this content.

(Don't forget the corresponding 'End If')

[bakerman2]

Let's start with this.

Please Login or Register  to view this content.