Hi There,
I've created a form in Excel for work and I've got everything perfectly how I want it. That was until I went to print...
The form is 2 pages, I've put in page breaks but I can only print both pages in portrait or landscape. What I need is the first page to print off as a portrait and the second as a landscape so it can be a double sided form that is printable at the click of the print button.
I hope this makes sense. Any help would be greatly appreciated. Thanks.
Hi Robioto,
easiest way to do this is to split your form into 2 sheets. Then you can have your page set up for each individual sheet.
If that's not an option I think the only way is to name both the areas to be printed (e.g. Portrait and Landscape) and then have a macro selecting one area at a time and have it printed in the desired orientation.
Such a macro could like this:
Just try if it works.
Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Hi Robioto,
can you please let me know if me last post worked for you?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks