I am trying to print various tabs in my workbook via VBA code. I can easily print one tab and then print the other, but what I would like it to do is print both tabs together as one print job (so that my printer can auto staple the two printed tabs together). Any thoughts?
Last edited by bigmantitus; 09-25-2013 at 05:54 PM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
This was indeed solved. I realized I could use an array to select the sheets. My code unhides tabs, selects them, goes to print preview (for printer selection), then very hides the tabs. My final code was as follows:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks