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
ADVERTISEMENT
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
Jul 24, 2007
How can I make a standard VB looking "PRINT" button as a button in one of the cells
in Excel where I can just hit PRINT , ONE TIME, and it prints out a copy immediately without having to show the print setup page and without any more confirmations?
View 6 Replies
View Related
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()
Sheets("Actual").Select
Application.Goto Reference:="Actualprint"
ActiveSheet.PageSetup.PrintArea = "Actualprint"
Sheets("Deposits").Select
Application.Goto Reference:="Depositsprint"
ActiveSheet.PageSetup.PrintArea = "Depositsprint"
Sheets("Debt").Select
Application.Goto Reference:="Debtprint"
ActiveSheet.PageSetup.PrintArea = "Debtprint"
If Range("SelectVariance") = True Then Sheets("Variance").Select.........................
View 6 Replies
View Related
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
View Related
Sep 15, 2014
I have 8 excel worksheets which I intend to make a PRINT button in sheet 1 so that I can run the button to print selective sheets. how to create one?
View 4 Replies
View Related
Nov 24, 2008
I have a workbook with approximately 260 sheets. These sheets contain financial information. They have to be sorted according to the division within the company, with a total page for each financial division.
I have a code on a blank tab that prints the sheets based on a value in cell B3 on each sheet. (i.e. "VB", "WB", which are initials of our district managers.)
View 6 Replies
View Related
May 17, 2007
I have been given a workbook that contains say 10 sheets. The first sheet is a summary sheet that will contain a 'Print' button. The idea is that when the Print button is selected all the sheets that's have been filled out will be printed.
For example.
I have a workbook that has 10 sheets to fill out. The user has filled out 7 out of the 10 sheets and when selecting the Print button, I require only the 7 completed sheets to print.
I thought the best way to go about this was to look at 1 particular cell on each sheet. If the cell is blank, do not print the sheet, otherwise do so.
View 9 Replies
View Related
Oct 16, 2008
I need to know how to make a box that says "print" which will print out pages in my excel file... What I am picturing is this:
Tab 1 Y
Tab 2 Y
Tab 3 N
... etc.
Making a table as the one above, and depending on whether I input "Y" or "N", it will print that tab...
i've seen this in some financial models and would like to incorporate it into my model. If you could offer some detailed help, it would be greatly appreciated. Please note that I am a complete beginner and would need to be taken step-by-step.
View 9 Replies
View Related
Jun 11, 2009
I have a print button on several sheets in a workbook. I have a code set for it so that when it is clicked, it will bring up a print dialog box. It looks like this...
Sub Button14_Click()
Application.Dialogs(xlDialogPrint).Show
End Sub
However, on one or two of the sheets, I would like a message box to also display when this button is clicked. The button is called Button14_Click()
Private Sub Button14_Click()
MsgBox "Please print new signature cards for customer(s) to sign"
End Sub
View 9 Replies
View Related
Jul 13, 2006
I have a workbook that has about 50 pages on 7 different tabs. I would like to add a print button next to each page that would only print that specific page or range. Is there a way to do this? For exampe I have a page that is named equipment log, Cells A1 through A33 are what I want to print if someone hits the print button. I don't want it to print the entire worksheet because it is 51 pages.
View 2 Replies
View Related
Mar 29, 2013
I have a sheet that I would like to print to one page (11x17, landscape) and have it take up the majority of the page. The largest the sheet will ever be is data in rows 1 - 71, and columns A - AC. Right now I have it set up so that when i click on the button, the print dialog opens up and no adjustments are needed to print to pdf in 11x17 for the maximum amount of data.
Overall what I am trying to do is have the zoom change when rows are deleted (columns will always be A-AC). The top 5 rows and bottom 5 rows will always be there. I want the top and bottom margins to be the same on the pdf even if 10 rows are deleted in between.
View 1 Replies
View Related
Mar 23, 2014
I have a print button or object and I want to assign a macro to it that when clicked brings up a prompt to type in a Month or Year to Date and prints the data that corresponds to that month or YTD. I have a Date column in a table that I can get a different macro to print by basially having the macro filter by blanks, so essentially printing all the dates in the table, but I feel as if it could be much better and simpler by prompting the macro to filter by "x" Month and print.
View 3 Replies
View Related
Jan 10, 2008
I thought I solved it, but it was on a different workbook. I am not in pagebreak preview and it's not password protected. Why can't I insert an object to create to assign my macro?
View 10 Replies
View Related
Apr 8, 2008
When I hit the print button on the Standard Toolbar, I want my printer to print only the number of pages specified on my worksheet which I previously entered into Cell A1.
Is there a formula or something I can use for this?
View 14 Replies
View Related
Oct 27, 2008
I need the Standard Print button to print only the number of pages I've entered in Cell X1 when I click it, (and if I haven't entered any value in Cell X1, nothing should be printed.)
Now, where this gets tricky, is that I still want to be able to override this automatic number printing if I want, by selecting 'File/Print...' from the menu and choosing a different number of pages to print.
View 14 Replies
View Related
Nov 11, 2012
All, I am trying to generate a print button that prints a specific range without using macros. Is it possible? Currently I am using Follow Hyperlink Sheet Event to print the desired range, this works fine but I want to completely lose the macros in spread sheet.
View 2 Replies
View Related
May 24, 2007
I am trying to create a simple macro to print a worksheet with a button. The worksheet will have additions/deletions on a daily basis, so it need to adjust accordingly. I cannot figure out how to do the loop macro.
View 9 Replies
View Related
Jun 25, 2006
I want to make a button in a cell that when clicked it will make cells A1:M25 the print area. Then in another cell I want another button that will make cells A28:M52 the print area.
View 5 Replies
View Related
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
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
Oct 9, 2009
I have a userform from which I need to be able to print a PDF document when the command button is pressed.
User enters the document number in docnum textbox (eg. 123)
On pressing the commandbutton printdoc, I need to be able to print document 123.PDF to default printer
All PDF Documents reside in a network folder mapped to the S:PDFdrive.
If the document is not found I need to display an error message stating this and return focus back to the textbox.
If the document is found I need to display a message stating document sent to printer.
View 6 Replies
View Related
Dec 29, 2011
Is there a way to disable the Excel print button and force someone to use a macro button to print the spreadsheet?
View 1 Replies
View Related
Jun 10, 2006
I've created a Small Program to print envelps and everything is ok. My request is how to print all Itemes by one button (printall).
View 2 Replies
View Related
Aug 10, 2006
I need to select a print area that includes all rows to the last row with data in column A. What is the proper code for this? I tried the following (shot in the dark), and of course it doesn't work.
Sub Print_()
ActiveSheet.PageSetup.PrintArea = "A( Cell((65536).End(xlUp)):X1"
ActiveSheet.PrintOut
End Sub
View 9 Replies
View Related
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
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
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
Oct 17, 2013
I have been trying to see if I can set up a single (A1) print button to create a selection box to select a name range and than print that range, but have been unable to figure out how to accomplish it. I have 26 name ranges called PP01 thru PP26 and I want to be able to select the range before printing.
View 1 Replies
View Related
Dec 29, 2009
Is it possible to create a command button to print the sheet, and, have a prompt come up and ask you to enter a date? Then that date is entered in a cell and the sheet prints? Just not sure where to start. I know how to make the command button and get to the view code for the button.
View 9 Replies
View Related
