Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing forom different tabs
I want to print just the first page from several tabs in a workbook.
The code is: ActiveSheet.PrintOut From:=1, To:=1, Copies:=1 But how do I write the macro so that the printing selection is repeated for the next tab until the end of the workbook? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing forom different tabs
Fredrik,
Here is something I have used it has worked pretty well for me. Sub PrintAll Dim wks As Worksheet Application.ScreenUpdating = False On Error Resume Next For Each wks In Worksheets wks.PrintOut From:=1, To:=1, Copies:=1 Next wks Application.ScreenUpdating = True On Error GoTo 0 End Sub "Fredrik" wrote: I want to print just the first page from several tabs in a workbook. The code is: ActiveSheet.PrintOut From:=1, To:=1, Copies:=1 But how do I write the macro so that the printing selection is repeated for the next tab until the end of the workbook? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting a month name forom a date | Excel Worksheet Functions | |||
Printing Tabs on one page | Excel Discussion (Misc queries) | |||
Returning a value forom a Module to a Userform | Excel Programming | |||
Printing a list of tabs off | Excel Discussion (Misc queries) | |||
Printing Tabs | Excel Discussion (Misc queries) |