Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Printing order
Howdie,
I have a macro that loops through all the sheets and prints them - however it prints them in the order they were created, not in the order that they are displayed on the screen. How can I get Excel to print them in the order that they are visible...? Thanks and Regards Darin Sub PrintVisibleSheets_2() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Visible Then If ws.Name < "data" Then ws.PrintOut Copies:=1, Collate:=True End If End If Next End Sub *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Printing order
I couldn't reproduce it. It looped in the tab order for me.
-- Regards, Tom Ogilvy "Darin Kramer" wrote: Howdie, I have a macro that loops through all the sheets and prints them - however it prints them in the order they were created, not in the order that they are displayed on the screen. How can I get Excel to print them in the order that they are visible...? Thanks and Regards Darin Sub PrintVisibleSheets_2() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets If ws.Visible Then If ws.Name < "data" Then ws.PrintOut Copies:=1, Collate:=True End If End If Next End Sub *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing order of worksheets | Excel Discussion (Misc queries) | |||
Printing order | Excel Programming | |||
Printing in reverse order | Excel Programming | |||
Printing in reverse order | Excel Discussion (Misc queries) | |||
Printing sheet order wrong for workbook | Excel Programming |