Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook
Hi...
Looking for some code to print all worksheets within a workbook and put in page numbers consecutively. Any help appreciated. Gordon. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook
Hello Gordon, I can give you the code to print the worksheets, but pages number in Excel are a quite another matter as Excel doesn't provide any VBA code to automate accessing, calculating. or manipulating page numbers. Sub PrintWorksheets() Dim Wks As Worksheet For Each Wks In ThisWorkbook.Worksheets Wks.PrintOut Next Wks End Sub Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=513952 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print workbook
Leith Ross wrote
Hello Gordon, I can give you the code to print the worksheets, but pages number in Excel are a quite another matter as Excel doesn't provide any VBA code to automate accessing, calculating. or manipulating page numbers. Sub PrintWorksheets() Dim Wks As Worksheet For Each Wks In ThisWorkbook.Worksheets Wks.PrintOut Next Wks End Sub Sincerely, Leith Ross How about this for page#'s?: Range("A1") = ExecuteExcel4Macro("Get.Document(50)") -- David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Shared workbook losing print settings | Excel Discussion (Misc queries) | |||
Macro to open print window and set to print entire workbook | Excel Discussion (Misc queries) | |||
changing print area in an entire workbook | Excel Worksheet Functions | |||
Print Spreadsheet tabs in a Workbook to a List? | Excel Discussion (Misc queries) |