Printing worksheets with a click of a button?

[ivwshane]

I have a workbook that has multiple worksheets that need to be printed. Is it possible to have a button that the user presses to auto print the worksheets?

Going one step further, could I some how incorporate a check box or a drop down box to specify which sheets are to be printed?



I'm an excel noob so any links to examples would be welcome.

Thanks

[VBA Noob]

See if links help

Displaying a Menu of Worksheets to Print


Print tips for Excel


Printing Multiple Sheets

VBA Noob

[ivwshane]

Thanks, unfortunately I'm not ready for VB yet:o I've just started teaching myself how to use macros.

[VBA Noob]

Copy the below code. Press Alt + F11 > Insert Module > paste in code then close VB window. Then press Alt + F8 and select "SelectSheets" from list

See link to add a shortcut key

http://www.bettersolutions.com/excel...C216621011.htm

Please Login or Register  to view this content.

VBA Noob

[bth117]

I'm trying to add "Select All" and "Select None" buttons. After

Please Login or Register  to view this content.

I'm adding

Please Login or Register  to view this content.

at which point I want to name them, so that I can have a private sub called CommandButton7_Click (the actual name doesn't matter) at the bottom to do the code of selecting all checkboxes. However, I can't seem to name these buttons since they are created automatically (instead of having a userform??). I don't know the syntax that would get me to

Please Login or Register  to view this content.

I don't care if i reference a private sub with "Click" or if i reference an outside Macro that does the code, but I'm stuck here.

My other problem is that I'm going after a moving target. If i use another checkbox, instead of a commandbutton, I don't know what number checkbox I will be on, since the number is dependent on the number of sheets to print... different with every .xls file.

Any ideas?? Thanks.

[royUK]

There's a userform here that you can drag into your workbook