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
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
Last edited by telekomhater; 01-14-2011 at 05:52 AM.
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.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
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.
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.
Hi Leith,
a big THANK YOU from Germany. Now it works as it should do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks