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 [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
