Macro to print all or selected worksheets

[Mldeuser]

I have a workbook that has about 20-25 worksheets, is it possible to create a macro that will allow you to either print the entire workbook or to select the tabs you want to print.

 

[Jon von der Heyden]

Hello

You shouldn't need a macro for that. When you go File > Print you are presented with the option to print the enire workbook, the active sheet(s) or just the selection.

You can group your sheets by holding down CONTROL and clicking on each sheet and choose Active Sheet(s).