prints

I want to create a macro that Prints 3 sheets from my workbook and then launches the saveAs window The 3 sheets I am looking to print are "Team 1" "Team 2" & "Team 3" Is this possible to do in one macro since there are windows that will pop up for both printing and save as?

Good Day, I have button when clicked it prints a range of rows on a template. Application.Dialogs(xlDialogPrint).Show RowCount = Range("B2") Worksheets("Payslips").Select For i = 1 To RowCount Step 5 Range("B4").Value = i ActiveSheet.PrintOut...

When I try to print only the visible cells after filtering,it prints one row per page, instead of all on one page. If there is no filter on it prints correctlyall on one page. This is my code: FinalRow = Cells(Rows.Count, 3).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = Range("C7:M" &...

Good afternoon I have a a VBA (EXCEL) which looks across columns and rows then prints a series of sheets accordingly what happens is a preview window pops up I still need the selection of a printer but would like then to print with no interference

Good morning, hopefully this is an easy fix. I have a graph that displays the axis on the screen slanted but when I print it, it prints straight. I have another graph on the same page that prints and displays slanted correctly. Anybody has any ideas on how to fix this? Thank you!

Hi everyone, I own a printing business and there are a TON of variables in print pricing lol. So I need a formula for multi-page booklets (like catalogs) Basically I will put a formula in that will come up with the number of prints it will take to make a multi-page booklet and I need the...

Hello, I am working on solution that will help to manage huge amount of prints. Those prints are triggered with macro loop depends on number of data. So when there is 100 prints, all prints are displayed in PDFCreator as current workbook name title. What I want to accomplish is to change or...

I found a vba code that I copied on this forum that lopps through a slicer and selects / deselects each name and bring up the relevant data for that person and prints it. It works but for some reason it keeps creating prints about 104 pages when there are only 39 names in the slicer. The last...

Hi all, Because I need to print on other printer than default, I use VBA code to show all available printers, then select needed printer & print: Sub Show_PrintersDialog_and_Print_Cards() Application.Dialogs(xlDialogPrinterSetup).Show Call Print_Cards End Sub The problem is this...

Hi folks, I'm currently working on a user form which populates a worksheet and then prints, I am trying to add a question to the user form in which the user must answer correctly for the sheet to print. This is my current code which does not work Private Sub CommandButton1_Click() 'populates...

I have a worksheet where one macro creates a new worksheet from a pivot table and prints a copy for an employee's record. That print is in color and portrait even though the code says to print b&w and landscape. While also creating a new worksheet the code creates a button on the new worksheet...

how can we count the number of prints taken for a sheet in a cell.

Im trying to create a VBA that reads in a certain cell value (any number from 1 to 10 depending on the input from the user) and then changes to value to read "1 of 10" and prints out a sheet. Then the value increases to read "2 of 10" and prints out again, this needs to continue until all the...

Hi everyone, I am messing around with Excel and as an assignment I need to create a VBA function that prints my name 10 times in a loop. Then I need to create a button that will trigger the function. How can I do this? I tried: Module Hello Sub Main() MsgBox ("Hi, my name is Pat") End...

Hi I have the following code that saves and prints just the visible tabs in a workbook, but I want to change the code so that it only saves and prints the first two tabs only could do with a little help if possible :) Sub SaveShts() Dim Ws As Worksheet Application.ScreenUpdating =...

Hello, I have code to set the print margins on an excel sheet with 9 sheets printed. The code is the following: <code> ActiveSheet.PageSetup.PrintArea = "$A$14:$P$87,$A$88:$P$155,$A$162:$P$221,$Q$14:$AE$87,$Q$88:$AE$155,$Q$162:$AE$221,$AG$14:$AV$87,$AG$88:$AV$155,$AG$162:$AV$221" </code>...

Hi all Right, I need a macro that changes a cell in my sheet then prints all active sheets via PDF. Sounds really short and simple but I'm getting nowhere quickly. My spreadsheet contains a lots of hidden pages which I don't need prints hence just active sheets plus the list of cell changes...