print selected tabs of worksheet

[telekomhater]

Hi everybody, hopefully somebody is able to solve my excel problem. I have a worksheet containing a lot of tabs (example file attached). Now I want excel to print out the tabs marked with an "x" in "main". Article and tab-name are always identical

[Leith Ross]

Hello telekomhater,

Welcome to the Forum!

The macro below has been added to the attached workbook. A button has been added to the "Main" sheet to run the macro.

Print Selected Sheets Macro

Please Login or Register  to view this content.

[telekomhater]

Hi Leith,
many thanks again for creating this macro. Would you be that kind and let me know what I have to change inside? I want the macro to look up the 10th column for "x" and it should start doing this in line 6. I tried a lot, but can't get it to work.

[Leith Ross]

Hello tlelkomhater,

The macro has been changed to start looking for "x"'s in column 10 (J) starting at row 6.

Please Login or Register  to view this content.

[telekomhater]

Hi Leith,
a big THANK YOU from Germany. Now it works as it should do.