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)...
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.
Is it possible to adjust the print area program-ably?
I have a print area of say Cell A1 to Cell E50. This will do for 80% of my needs. Occasionally the table may extend another 15 rows or so. For this I would like to add a column F and use an "If" statement like If(E51 <>"", Set print area A1...
Hello all not sure if what im needing is quite possible.
Im needing a Macro to Sort a range and Print it without haveing to Sort the actual excel. Just need the Sorting to occur for print purposes not to effect the actual excel.
Hi,
Is there anyway to do a multiple print job in a single sheet quickly?
For example, in this sheet call 'Shop Ticket', there are 100 pages.
Sometimes, I need to print page 1-10, or 1-50 or 1-100.
Sometimes, I need to print page 1-10 and 11-20 and 21-30 and 31-40 etc etc.... BUT all in...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.