Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

printing excel workbook

Comment:

I have an excel 2007 workbook which contains 22 worksheets. When I use the print option to print entire workbook, it prints all of the worksheets but not in the order that they are laid out on the tabs across the bottom of the workbook. How do I change the print order of the worksheets if their tabs are already in the order I want them to be printed? thanks!

Name: DerbyDad03
Date: March 5, 2009 at 07:56:06 Pacific

Reply:

If you put this code in the ThisWorkbook module of the VBA editor it will print your sheets in order. Private Sub Workbook_BeforePrint(Cancel As Boolean) For Sht = 1 To Sheets.Count Sheets(Sht).PrintOut Next End Sub

0

Reply:

Thanks so much for your response! Now I don't have to sit and re-order my workbook pages after printing them.

0

putting colour in a cell ...

Sum if against 2 veriable...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi All, I am trying to reference an excel workbook that is on a LAN (at work). The idea is to copy the contents that is on sheet1 and paste it on sheet1 of the workbook where the macro is running. It ...

Summary: Forgive nube/duh-ness, does anyone know what causes Excel 2003's workbooks no longer come to the front (when other windows are open in front of it)? It doesn't matter what kind of an open window is in...

Summary: I have an excel workbook with multiple worksheets, each shee­t has multiple pages. When in print to an HP LaserJet 4100 B&W pri­nter the pages come out upside down and in the correct order. sheet ...