Print Multiple Worksheets As 1 Print Job

Jun 2, 2008

I'm using VBA code to select several worksheets at once, and print them. The code runs fine, but the result is multiple print jobs, not one job. This is OK when printing to the printer...but undesireable if you want to print to a pdf file, for example.

I've searched the site and found some references to this possibly being an excel problem. Is that true?

I've also checked the page setup setting to make sure that the print resolutions are all the same...that doesn't appear to be the problem either.

View 6 Replies


Print Selected Worksheets As One Print Job

Apr 23, 2008

I have a macro to print selected worksheets. It works well with one small problem. Whether I select the last worksheet or not, it always prints. I have tried a bunch of different ways to get around this, and all I succeeded in doing was getting a separate page printed first, then it would print the rest of my selection.

Sub PrintReportSelection()
Application.Goto Reference:="Actualprint"
ActiveSheet.PageSetup.PrintArea = "Actualprint"
Application.Goto Reference:="Depositsprint"
ActiveSheet.PageSetup.PrintArea = "Depositsprint"
Application.Goto Reference:="Debtprint"
ActiveSheet.PageSetup.PrintArea = "Debtprint"
If Range("SelectVariance") = True Then Sheets("Variance").Select.........................

View 6 Replies View Related

Print Multiple Pages And Worksheets To PDF?

Aug 25, 2013

In my excel, i have 3 worksheets. On the first worksheet, i have 2 pages since i have 2 sections side by side. I can't stack the sections due to different column widths. I am trying to see if there is a macro to stack the 2 pages on the first worksheet as one pdf page, and then have worksheets 2 and 3 as pages 2 and 3 of the pdf.

View 1 Replies View Related

Print Specific Worksheets In Multiple Files To PDF

Aug 13, 2012

I'm trying to find a solution to print to PDF specific worksheets in multiple Excel files. The files reside in the same directory, and I would like to be able to print them all at once to PDFs.

View 3 Replies View Related

Print Multiple Pages With Single Print Job

Feb 14, 2007

I have a spreadsheet with 28 visible tabs. When I select all tabs and print, I get 3 cover (or banner) pages...I like having the first banner page, but the other two are in the middle of my report. I assume excel is sending 3 print jobs and I'm not sure why.

I've seen a couple of posts regarding this issue when using VBA, but I'm not using VBA...just selecting all the sheets and sending a single print job, but get 3 banner pages.

View 9 Replies View Related

Print Entire Workbook Prints Pages Out Of Order And Makes Several Print Jobs?

Mar 26, 2013

All sheets are basically the same except some minor values, names and addresses. There is one page per sheet and all pages are in portrait format. The print preview shows all the pages in order but when I print it, it makes multiple print jobs of 1 to 2 pages each and prints them all out of order. I don't know why it is splitting up the workbook or why it changes the order. I print and reorder these weekly, which is a major pain. It comes out in the same order each time but it is the wrong order.

View 1 Replies View Related

File Print In Legal Size If I Have 56 Lines Filled In Then Print In Regular Letter Si

Oct 15, 2005

I am trying to have a file print in legal size if I have 56 lines filled in
otherwise print in regular letter size. Does anyone know how to write this
in VBA.

View 10 Replies View Related

Macro To Print Sheets With Value In Cell A1 But Print Dynamic Ranges On Certain Sheet

Sep 24, 2013

I've found some code which works to print certain pages with value in cell A1 but I need to print dynamic ranges on some of the sheets as they will have filters on so the rows ranges will be different each time.

So far this is what I have but the dynamic range part is not working:

Sub Print_All_Worksheets_With_Value_In_A1()
Dim Sh As Worksheet
Dim Arr() As String
Dim N As Integer

[Code] ....

View 3 Replies View Related

Excel 2007 :: Content Shown On Worksheet Different Than Print Preview And Print?

Jul 17, 2014

Since upgrading to Windows 2007 (I was already using Excel 2007) I am having issues with the content in the cells on the worksheet not appearing the same on Print Preview and when I print. On the worksheet the cell show to be at the best fit both horizontally and vertically. When I look at the contents under print preview, the contents are squashed from the top and cut off from the left. This happens whether I have the format in Top or Central align and is even worse if I use Bottom align. It is also somewhat worse if I have thickened boarders.

I am using TrueType Fonts.

View 8 Replies View Related

Excel 2010 :: How To Apply Print Titles To Print On Select Pages

Dec 10, 2012

Using Excel 2010: I have 2 rows (A4:J4 & A5:J5) selected as print titles that I would like to be printed at the top of selected pages. Currently, my document is 3 pages long, and I would like to have the print titles only applied to the first 2 pages. More data will be added in the future on pages 1&2 but the last page (whatever page number it ends up being) should not contain the selected print titles.

View 2 Replies View Related

Print Previewed A Worksheet And Find A Tiny Image With A Small Portion Of The Print Area

Mar 27, 2009

I just converted from Excel 2003 to 2007 and print previewed a worksheet and find a tiny image with a small portion of the print area. When I look at the sheet in page break preview mode, I see the 8.5 x 11 sheet broken up into approx 77 smaller sheets. When I try to move the page breaks to include the whole sheet it states the change cannot be made as it will result in an image less than 10%. I have attached two images - the first shows the print preview I get, and the second show the multiple pages when I view in page break.

View 4 Replies View Related

Allow Users To Print Hidden Sheet But Not Change Print Settings

Jul 2, 2009

I am having trouble disabling the "Preview" button when calling Application.Dialogs(xldialogprint) in XL2003. I have an xlSheetVeryHidden worksheet containing a form which is made visible programatically when the user wishes to print a copy (code below). I want the user to be able to have access to the functionality of the xlDialogPrint dialog (i.e. select desired print destination, number of copies, pages per sheet etc.) but I also want to prevent them modifying the page setup of the protected worksheet by initiating a preview from the print dialog.

Private Sub btnPrintReturnForm_Click()

wbkRUSC.Unprotect sysPass 'unprotect workbook to enable changes to sheet visibility
' (sysPass is project constant string containing password)

shtStaffForm.Visible = xlSheetVisible 'make staff form visible

shtCalc.Visible = xlSheetVeryHidden 'hide main calculator in case user gets smart and hits..............................

View 5 Replies View Related

Find Print Range And Print Invoices From 250 Tabs

Feb 24, 2014

I have a pretty large spreadsheet set up that invoices our clients. A few tabs in the front allow us to globally invoice if we did certain services for all clients and then we can also go into each tab and invoice each client for specific services performed on their property. Some invoices are two pages long and other may be up to seven pages long and anywhere in between... So that's the first issue, how do you find how many pages to print and then set the print range for each invoice.

The second issue centers around being able to print all the invoices at one time.

The spreadsheet is set up in this manner: A recap sheet we print to check off that each invoice was printed; an IIF statement to get the Excel info into QuickBooks; a template to set up each invoice's information with dates, dates services were performed,etc.; then there are five Global billing tabs where I can invoice all accounts globally or by their type of account (Saturday or Sunday open, 24/7 etc.); then we get into the tabs for each account. Each account has its own tab with an invoice loaded inside where we can itemize the services they received. Inside all these individual account tabs we have set up 'Zone' tabs where we can invoice all the clients we set up within a zone. There are about twenty of these tabs. Then at the end I have a few more tabs that aren't used any longer, there are about ten tabs there...

Is there a way I can hit Print and get all of my invoices to print out at one time versus having to go into each and every tab, set the print range, and then hit Print for all 250ish invoices?

This is the biggest complaint I have right now about the invoicing program I have set up...

View 4 Replies View Related

Print Out Data That Is Variable In The Amount Of Rows To Print

Apr 15, 2009

I am trying to come up with a way to print out data that is variable in the amount of rows to print.

1. Cells C1 thru M6 is heading of report
2. Cells C7 thru M400 all have formulas and display information only when criteria in Column C in each row is met, if condition is not met it displays no informtion. (There lies my problem).

I need a way to print out only the area that information is displayed in and skip the areas that are not displayed. (Currently I have hard coded the print range using the largest report)

View 6 Replies View Related

Stop Print Macro Firing Before Print Event

Oct 18, 2006

I have a "submit" button macro which user would click after he has finished his input. This macro would update a reference number on the worksheet named "orange" and then print out this worksheet.

My purpose is "orange" is printed out with a reference number.

Below is the 1st code.....

View 9 Replies View Related

Print Only Certain Worksheets

Mar 21, 2002

I want to make a popup or some type of inquiry menu where it asks the user to specify which worksheets in the workbook to print. I have a data entry page, and four printable worksheets.

Sometimes I only want to print two of the worksheets, but not the data page or the other two. Any way to do this besides printing the entire workbook or one worksheet at a time? It would be ideal if a popup menu came up with checkboxes for all of the available worksheets and the user could check off which ones to print.

View 9 Replies View Related

Print All Worksheets As PDF

Jul 24, 2008

I have a template with 25 very hidden sheets in it, my userform, unhides and slightly modify's some of the sheets. When my userform is completed, there are between 2 and 11 sheets visible. I am trying to put code behind a button on a sheet that will save all sheets to one PDF file. The code below works but makes individual files.

select all active files as pdf

I know it's close but the code to select all active sheets is messed up.

Sub PDFit() ...

View 9 Replies View Related

Disable Print For The Set Of Worksheets

May 11, 2014

Is there any chance to cancel print for set of worksheets? For example in workbook with Sheet1 to Sheet4, i wish to allow printing only for sheet4 and all other sheets to disable print.

View 6 Replies View Related

Print Button On Various Worksheets?

Jan 8, 2014

I have an Excel form that contains 7 tabbed worksheets, one for each day of the week Sun thru Sat, that is a nutrition tracker and an 8th tab which is a food library. I put two buttons on the food library to automatically sort it by different categories and they work great for me. Then I put a printer icon on each of the daily sheets to print a single worksheet (in B&W) with the following macro changing the "from" and "to" to correct worksheet number for each day. Screenprint below.

Using "Monday" worksheet as an example I first tried using sheet number 10 as shown in the VBA Project below for the "From" and "Two" and it printed the wrong pages, so I went to the worksheet number as they are tabbed in the file, Monday being sheet 2, and it works fine (on my computer).

It works great from my computer, but if I send it to someone else and they try to print they receive the following errors: When they open the spreadsheet and click the print button this error comes up:

If they click "OK" on the above error this comes up

I've tried to include information that is revelant.

View 2 Replies View Related

Print Specifice Worksheets

Feb 14, 2007

I am looking for a way to have print icons on my spreadsheet that will print certain worksheets once clicked on.

For example: My spreadsheet has several countries, UK, France, Germany...

If clicking on the print icon next to Germany - i would like only the German worksheets to be printed - there would be several worksheets for each country.

View 9 Replies View Related

Set Print Orientation On All Worksheets

Feb 8, 2008

how would I change the orientation on ALL my worksheets, I'm saying every single one, imagine I got like 100 for the purpose of this excercise (sorry I'm not trying to make this harder, it's just there's always that one guy that'll come on and say 'Go to Print Print Preview, then click on Setup' or something like that.

So yeah, that's pretty much the question that I have for you brainaics:

How do I change the printer orientation setting to landscape on all worksheets (maybe a loop?).

View 3 Replies View Related

Before Print (Cancel Button Is Not Cancelling The Print)

Apr 10, 2009

I want my worksheet to require validation of entry data before printing, so I decided to use the "Workbook_BeforePrint" event, and display a simple dialog box with an "ok" or a "cancel" button as input options.

The problem is that, as coded, "cancel" button does not cancel the print.

View 2 Replies View Related

Locking Print Areas On 7 Worksheets

Feb 27, 2013

I have locked print areas on 7 work sheets. I have successfully printed them at 1 time. However it appears as if the print areas have to be set again before I print them again? What's up.

View 2 Replies View Related

Displaying Print Menu Of Worksheets?

Feb 4, 2014

In the excel file is a VBA code that is combined with a button if someone click on the button a little menu shows with a multiple options of sheets that can be printed. Only the problem is when i hide the sheets the code doesn't see them anymore and the only I can print is the page where the button is placed.

View 4 Replies View Related

Display A Menu Of Worksheets To Print Out

Jun 24, 2009

I came across the following macro that generates a list of worksheets with check boxes to select the ones I want to print. I attached the macro to a button on my "Totals" worksheet. When I run the macro, it lets me pick the worksheets, but doesn't print anything unless "Totals" is one of the worksheets I selected in the dialog box. What is missing?

I also want to stop the screen flickering and have it go back to the "Totals" page when it's done since that's where the button is.

View 14 Replies View Related

Print Worksheets Based Upon Criteria

Oct 23, 2006

I have a monthly template that has 31 tabs labeled 1 through 31 for the days of the month. I would like to add a macro that would print only the sheets that have a value greater than 0 in either of two specific cells.


Sheet / Cell B2 / Cell B36 / Action
1 / 0.00 / 0.00 / Don't print
2 / 100.00 / 0.00 / Print
3 / 0.00 / 100.00 / Print
4 / 100.00 / 100.00 / Print

I could add a summary sheet that would pull over these values and/or add if statements that return results like "don't print" or "print" if it would be easier in the macro or I could just use the code in macro to determine to print or not.

I am a record and tweak macro user and this isn't something you can record. I found some simple code in another post that would print one page based upon single criteria but it isn't exactly what I was looking for.

View 9 Replies View Related

Userform To Print Visible Worksheets..

Sep 20, 2007

I have a form to allow users to select and print pages from a workbook.

Private Sub UserForm_Initialize()
Dim sht As Worksheet

For Each sht In ActiveWorkbook.Worksheets
ListBox1.AddItem sht.Name
Next sht
Me.Height = 128
End Sub

Only problem is that this lists all worksheets in the form. Need to modifying it so that it does not list worksheets that are xlSheetVeryHidden.

View 2 Replies View Related

Macro To Print Existing Worksheets

Feb 12, 2008

I'd like to create a macro that can access few existing worksheets from different workbooks and print them automatically when i press the button or select them.

Tried userform and listbox that were suggested from other thread, but that didnt work quite well since I'm not quite understand the code behind it.

View 9 Replies View Related

VBA Macro To Consolidate Several Worksheets Into One & Print

Apr 11, 2009

I used a Macro from here that creates one worksheet from several then prints and deletes it. However the Macro doesn't carry over my column/row size formats. Is there a fix?

View 2 Replies View Related

Print All Worksheets Before Specific Sheet

Apr 21, 2008

I am seeking the most efficient code to print all excel worksheets beginning with sheet "XYZ" and ending with the last sheet in the workbook.

- Sheet "XYZ" is always the starting point
- The number of sheets after "XYZ" is variable
- The names of the subsequent sheets are unique and not sequentially named/numbered
- The printing will be to one report (i.e. don't print pages individually)

View 2 Replies View Related

Copyrights 2005-15, All rights reserved