Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, I would like to join these together, but have the second macro
only apply to the sheets monback,tuesback,wedback,thursback,fridback,satbac k as they are the only sheets that may have two pages to print. The print button will be on a sheet called starta. Thanks code below.... Sub PrintMontoFrid() 'Print out End Of Week Stats Application.ScreenUpdating = False Sheets(Array("monday", "monback", "tuesday", "tuesback", "wednesday", "wedback", "thursday", "thurback", "friday", "fridback", "saturday", "satback", "weekly")).Select ActiveWindow.SelectedSheets.PrintOut copies:=1 Sheets("starta").Select Application.ScreenUpdating = True End Sub Sub Print1or2pages() If Range("total1") 0 Then ActiveSheet.PrintOut From:=1, To:=1 If Range("total2") 0 Then ActiveSheet.PrintOut From:=2, To:=2 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macros Don't Show On Commands List and 'Normal.dot' | Excel Worksheet Functions | |||
Deleting phantom macros | Setting up and Configuration of Excel | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Macros for find and replace and then joining columns | Excel Discussion (Misc queries) |