How do I create a macro to print various tabs within a excel workbook and make them print ready?

[iouu2]

Took basics in Undergrad but don't even remember how to create a command button any more .

What I need is a command button that can make it easy to print various tabs within the excel workbook and make them print ready (meaning click of a button and you can select which tabs you want to print) and make sure the view for them are print to one page.

The tab in which the command button will sit can be called "Header".
The other tabs in the workbook will be Tab 1, Tab 2, Tab 3, etc. etc..

Thanks!

 

[HD Racer]

Here is a quick one to try, I used Excel 2003 to create this macro. I am not really sure how you would change the entry for a different a tab selection, except to have a button for each. Perhaps someone with more experience will know. This macro will print any or ALL your TAB pages created and named it the brackets from any page your button is placed on (re: "Header". Remember to assign your button to the new macro. Be sure to check your PRINT AREA before printing. Good luck.

'</SPAN>
' PrintTabPages Macro</SPAN>
' Macro recorded 5/1/2014 by HD Racer</SPAN>
'</SPAN>
Sub PrintTabPages()</SPAN>
'
'Next step prints each tab out named in the brackets</SPAN>
‘</SPAN>
Sheets("Tab1").PrintOut copies:=1</SPAN>
Sheets("Tab2").PrintOut copies:=1</SPAN>
Sheets("Tab3").PrintOut copies:=1</SPAN>
'</SPAN>
</SPAN>End Sub</SPAN>