Hi board,
I'm not sure if this post really belongs in this forum, but I'll give it a try.
I'm trying to configure my excel printing behaviour so that it prints 2 pages on one sheet. I can do this manually each time via print-->properties-->finishing and then change the pages per sheet. I also already created a print task quick set in order not having to switch the prints per page, but still, it is a manual task every time again.
Can someone provide me a siple vba code that takes care of this everytime it press the print button? Ideally, the program would ask a confirmation to print 2 sheets on one page right after clicking the print button, so that in case you do want to print page per page, you can still do so.
any help is much appreciated.
regards,
shodan
I'm not sure if this post really belongs in this forum, but I'll give it a try.
I'm trying to configure my excel printing behaviour so that it prints 2 pages on one sheet. I can do this manually each time via print-->properties-->finishing and then change the pages per sheet. I also already created a print task quick set in order not having to switch the prints per page, but still, it is a manual task every time again.
Can someone provide me a siple vba code that takes care of this everytime it press the print button? Ideally, the program would ask a confirmation to print 2 sheets on one page right after clicking the print button, so that in case you do want to print page per page, you can still do so.
any help is much appreciated.
regards,
shodan
