print

Greetings Recently I have been working on a VBA that does the following while launched in a separate macro-enabled Excel file: 1. Open Workbook1 in a separate process and choses a unit in validation list (drop-down menu list, what changes data on the Sheet1) 2. Copy Sheet1 to a new workbook (in...

Hi guys i want when i select a range, after that with run a macro, doing this 3 steps Paste in a sheet that named Sheet from cell A3 after that print from a sheet that named Print after that clear contents from A3 until rows of sheet that named Sheet be ended...

I'm using this code that I found in another thread. It opens a pdf file in Adobe Reader and prints it to a PDF. It works great, however, when I run the code, it triggers a dialog window in Adobe Acrobat, where you are suppose to enter the file name and hit save. I would need it to have the file...

Hi everyone. I have a multipage (single sheet) Excel file that is used as an application form. Blocks that needs to be filled in are filled with yellow color. Once the person fills it in, the block's fill becomes blank. Furthermore, there is a dropdown list that has a few options. If the option...

Hello, I need help. I wanted to remove the some cell color before printing. Some cell I have put the color (Green) for the user to know where to enter input. When the user enter "Ctrl+P", the Green cell will be removed. Below is the table :- Before Print Print Preview Info :- 1)...

Hi guys how to create a vba button for print preview or quick print from another sheet?

I have a 75-page spreadsheet that I want to be able to print a page or a range of pages without having to specify the normal way. Is there a way to be able to have a dialog box or have a cell dictate which page(s) I need to be printed?

I have played around with some VBA options but I’m not able to get what I’m looking for. I need to print individual certificates in PDF format, from the list within the same excel file. Each line in the list should be an individual certificate. The resulting PDF file naming should have the...

Hi, I am having some trouble with what should simple VBA code that is producing an error and locking up Excel when I run the macro to where I have to go to my Task Manager to force-close Excel. I am trying to have the macro select the 'Cover' tab in my workbook, then open the Print Dialog Box...

Hi I have a form that I would like to have the print function defaulted to Print to PDF I also would like the person to be able to preview the print prior this is the code I presently have that allows me to preview but not sure what to add in order for it to default to "Print to PDF"...

Hi All Simply I want to copy data entered in workbook 1 to workbook 2, after it has printed sheet 1 of workbook 2 on Mondays clear the cells of information. I am stuck mostly with clearing on Mondays. partial help would be as welcomed as a complete solution. In more depth: Workbook "Master...

Hello, I've got an excel workbook. There's a drop-down menu (validated) on the main worksheet I'd like to print to PDF. It populates data based on the drop-down option and the data is pulled from other worksheets. I'd like to 1) select from the drop down menu, 2) print the main spreadsheet to...

Hi All I currently have 3 sheets that I am required to print every Monday (but forget). I want to add a VBA to automatically print a sheet when the data rows which fall on a Monday are filled in. The print out comes from sheet/tab "KPI's" and the data which is compiled is under tab "Daily Data...

I have a worksheet in a workbook that I have created that, with manually assigned page breaks, has 276 pages in total. I am wondering if there is a VBA code that will allow me to assign what pages from the worksheet I have print out of those 276. There are times the pages I want to print will...

I have read through several posts and cannot find a code that will work correctly. I have a spreadsheet that has 700+ rows and 100+ columns. Column A contains a value of Y or N. I need a code , using a Toggle Button, that will print ONLY the rows that have a Y in column A. I know this can be...

I have a workbook with different worksheets. As these have different orientations you can't simply select and print them, as the page orientation is the same on all of them as on the first page. Now I would like to create a macro with which I can print the selected pages (which are not always...

I used the following code to print a hidden sheet and my first sheet disappeared .......can anyone tell me what the problem was, please TIA GT Sub PrintOnlyHiddenWorksheets() Dim CurVis As Long Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets With sh...

Hi all! I'm pretty sure this may have been answered before, but I'm self-taught in excel and know about 100% of nothing as far as coding goes, so I need to try an get this explained super simply if possible. The post I think I found before talked a lot about coding and something like VBA and I...

Hi, newbie to VBA here. I have been researching and trying many ways to select and print a range, and I cannot find a way to print cells with values only. In my case, I create a list of entries through the day. I am creating a button so I can print all of these entries at the end of the day...

Hi, For now, I go to print, select entire workbook, choose double sided, next page, rinse and repeat. The problem is I have 50 pages to do, is there a way to print the entire workbook double sided automatically? Thanks.