printing macro

  1. B

    printing code needs edited

    As you can tell the code below prints of the sheets that contain data in them. The trouble im having is about half way down there are some print settings that are only working on the active sheet. Im unsure what to replace the active sheet with so it will apply all the printer settings listed to...
  2. D

    VBA Code to prompt a user to print out

    I have some existing code that automatically prints a copy of a worksheet in my book #code Sheets("NMR Form").Select ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _ IgnorePrintAreas:=False #endcode Instead of automatically printing, I would like the user to...
  3. J

    Print 1 worksheet from multiple printer trays using VB macro

    I have no coding experience, but hoping this is a really easy fix. Here's what I'd like to do: Print worksheet from multiple printer trays at once (network printer). Right now, I have to hit "print", then do it again, but change the output tray. I print from 4 different trays every time I...
  4. A

    Printing using data from another worksheet

    I would like to print a worksheet changing only one field/cell (B27) with information from another worksheet ranges A1:A100. If there is no information in cell, would like it to skip.
  5. H

    Printing Macro

    My first time posting here and my first foray into VBA. I’ll try my best to be as descriptive and accurate here.... I have 2 tabs: “Customer Info” tab: this contains customer data in a table (name, address, etc.) that will be manually updated / input as needed. This customer data is then...
  6. V

    Print Specific Sheets, if sheets does not exist, skip

    Hello everyone, I am having difficulties. I have a workbook with several worksheets, Sheet 1, Sheet 2, Sheet 3. But some workbooks have Sheet 3 missing, so therefore I want my macro to skip that worksheet and continue. Here is what I got so far. Sub SpecficSheets() Dim wb As Workbook, ws As...
  7. T

    Need help with printing VBA Macro

    Hello, I need help with a printing macro. I have 4 sheets labeled "FINRA PV" and "FINRA Download" along with its corresponding months, and would like to automatically print all of them. However, I change the name of one them every month. Currently this is what I have: Sheets("FINRA Jul...
  8. DPChristman

    Using a macro to print embedded images or documents

    In my excel forms that I have created, I have my people using additional tabs to embed information (photos, receipts, statements, etc). The finished report is then distributed. My question is this: Is there a macro I can use to print these statements, receipts, etc. automatically. I know...
  9. J

    Macro for multiple printing to CutePDF

    Hi there, fairly new to macro's but I need some fairly complex coding for a project I'm working on. Basically I need a macro to do the following, Select the next item down on a drop down box, print to PDF using CutePDF as the printer and finally at the 'Save as' stage, use a cell within the...
  10. R

    Printing same selection of data on various worksheets in a worksheet order determined by a list

    Hello I am having trouble achieving the following and have searched through the forums without a clear answer. I have an excel document with 16 worksheets and a front page. On this front page I want to include a list that has the numbers 1-16 on it but in a different order (not alphanumerical)...
  11. M

    Print code with checkbox and print dialogue/summary

    Hi, I'm in need of some help regarding printing in excel with a vba code. At the moment I have a checkbox which pops up when you click the "Print" button I created on the sheet. But once you have selected the sheets you want and hit "OK" it goes straight through to the printer. I'm...
  12. A

    Printing one column into two (snaking)

    I have a list of products that I have employees use as a reference sheet to confirm item # with the right product. The sheet is set up as column A - item # column B - Item name column C - Small picture of item column D - how to package it As I need to add/remove products from time to time I...
  13. T

    Print Rows only if greater than zero

    I would like to make a worksheet for a material requisition but only print the line on the worksheet if the quantity required is greater than zero The blank worksheet would contain columns as follows Qty Required : item stock # : description : Weight : Cost : Extended Weight : Extended Cost ...
  14. C

    Batch Card Creation with changing tonne numbers

    Hi, I'm hoping someone can help me, I am making a batch card for work, that shows a batch number and weight that is fixed but changes for each tonne printed off. I have used a user form to get the number of tonnes etc. and need it to print on each card tonne numbers up to the amount entered...
  15. ed.ayers315

    Printing Macro "Advanced" help needed

    Hello Forum goers, I need help with building a macro to accomplish a complexed wish list. Tried numerous other solutions and tried combining some but could not get the needed result. I deleted rows from the worksheet so it would fit better and hopefully easier to follow; the far right...
  16. J

    Excel Print Macro

    Hi all! I have looked through a tun of threads about print macros, but none of them are quite what I'm looking for. First of all, I am using Excel 2010. I have a workbook that has roughly 150 worksheets in it with information for each of my employees. I am looking to set up a macro that will...
  17. A

    How To Group like sheets by name then print & loop

    Hi, Below is my code that will loop through a workbook and print each worksheet individually. I'm now trying to add code in order to find worksheets with the same account number in the sheet name and group them - then print, and move on the the next account... below is an example of 2...
  18. D

    Selecting tabs and printing

    Hi all, I produce a monthly pack which requires multiple worksheets in different excel files to be selected and printed (over 100pages). What I need to do is activate a workbook, select the required worksheet(s) then print, then go to the next workbook. For example, open up Report A file...
  19. B

    Help with Print Areas

    I'm having a bit of trouble getting Excel to play nice with the way I want a spreadsheet to print, stemming from a desire to have the print format look a bit different than the way it's displayed in Excel. The spreadsheet looks like this: ...and when I print it now, with the print areas...
  20. B

    Forcing the Print Dialog box even when the user hit the print icon on the toolbar

    I have a program that I'm trying to make printing easier. I'm trying to create a macro that will automatically bring up the print dialog box when the user hits ctrl+p or uses the icon on the toolbar. I know the command to bring up the print dialog box: Application.Dialogs(xlDialogPrint).Show...

Some videos you may like

This Week's Hot Topics

Top