$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help
Hi Rohan, Thanks for wishes and same to you ! I did a quick finding on how to print from back to front. You can give it a try. Follow the below steps 1) Go to page setup 2) In Page tab, there is an options button at the bottom 3) Click to open a properties window 4) On Advanced tab, There is layout options 5) Select Back to Front in Page order: field. 6) Click ok and print the page. I have enclosed a snapshot of the same for your reference. Do give a try and let me know if it helps you. Feel free to write back to us if you have further questions. Best Regards, Ayush Jain Microsoft MVP https://lh3.googleusercontent.com/_wa671SC3JRE/TR3_DHnhkcI/AR0/-Eb1SVQo8wg/back%20to%20front.JPG -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help
Hi Ayush Ji, Gud Morng with new year wishes, Thanks for the feedback, but the situation is same, neither my printer KYOCERA KM3060 is showing any option like that nor XeroxCentre, and the other question is can that commands or setting count the page nos. automatically on pages please help Thanks ROHAN 9818247278, 8860567680 On Fri, Dec 31, 2010 at 9:38 PM, Ayush jainayus...@gmail.com wrote: Hi Rohan, Thanks for wishes and same to you ! I did a quick finding on how to print from back to front. You can give it a try. Follow the below steps 1) Go to page setup 2) In Page tab, there is an options button at the bottom 3) Click to open a properties window 4) On Advanced tab, There is layout options 5) Select Back to Front in Page order: field. 6) Click ok and print the page. I have enclosed a snapshot of the same for your reference. Do give a try and let me know if it helps you. Feel free to write back to us if you have further questions. Best Regards, Ayush Jain Microsoft MVP https://lh3.googleusercontent.com/_wa671SC3JRE/TR3_DHnhkcI/AR0/-Eb1SVQo8wg/back%20to%20front.JPG -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Re: Change / Arrange no. of order of Sheets - Help
Hi Rohan, If your printer does not allow to print from back to front, you can use macros to reverse the order of the sheet. Please run the below macro to reverse the order sheet and then give print command. After printing the sheets, Run the macro again to make the original sheet order. * Sub reverse_sheet_order() Dim TotalSheets As Integer TotalSheets = ActiveWorkbook.Sheets.Count For i = 1 To TotalSheets Sheets(TotalSheets).Move before:=Sheets(i) Next End Sub* Please give it a try and let me know if it helps you. Best Regards, Ayush Jain Microsoft MVP. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts