Display A Menu Of Worksheets To Print Out

Jun 24, 2009

I came across the following macro that generates a list of worksheets with check boxes to select the ones I want to print. I attached the macro to a button on my "Totals" worksheet. When I run the macro, it lets me pick the worksheets, but doesn't print anything unless "Totals" is one of the worksheets I selected in the dialog box. What is missing?

I also want to stop the screen flickering and have it go back to the "Totals" page when it's done since that's where the button is.

View 14 Replies


ADVERTISEMENT

Displaying Print Menu Of Worksheets?

Feb 4, 2014

In the excel file is a VBA code that is combined with a button if someone click on the button a little menu shows with a multiple options of sheets that can be printed. Only the problem is when i hide the sheets the code doesn't see them anymore and the only I can print is the page where the button is placed.

View 4 Replies View Related

Print Menu

Mar 10, 2007

I would like to create a print menu similar to the one located at http://www.landlordsoftware.com/jpg/printmenu.jpg

build the print menu and set up the appropriate code to do so? I have more sheets than the sample linked.

View 7 Replies View Related

Forcing A Menu Sheet To Display On Startup

Jan 10, 2010

In a multi sheet workbook (Excel 2007), could some one tell me how to force sheet 'Main' to be displayed?

View 2 Replies View Related

Don't Display Blank Entries In Drop Down Menu

May 10, 2007

If i make the listfillrange of my combobox a named range, is there a setting in the combobox that allows it to ignore any blank cells in the named range.

Lets say my named range is cells A1:A5 but only A1 has a value, the rest are blank.

The combobox drop down menu will display the value of cell A1 and then 4 blank rows. Can i make the combobox igoner the blank rows and only display cells A1 in the drop down menu?

View 9 Replies View Related

Print Selected Worksheets As One Print Job

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

Print Multiple Worksheets As 1 Print Job

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

Menu / Links And Worksheets

Apr 19, 2009

I need to create a fairly complicated spreadsheet (well its complicated for an excel noob like me!)

Im after creating a spreadsheet with approx 100 different worksheets.

On sheet 1, I am aiming to create a drop down menu (or list) with links to the other worksheets. However, when i select an item from this list or menu, i would like the relevent worksheet data to be displayed in the bottom half of Sheet 1. If that makes sense to you! (basically to save me scrolling through all the sheets to find the info I need)

I would also like to have sheet 2 excluded from this list, and on sheet two I would like a list of all my other sheets.

If i can explain it a bit better for you, i am trying to list assest at aprox 100 different locations. So if i had assests in Aberdeen, Altrincham, Anniesland, etc I would have the assets for each location on an individual worksheet with that location name. So all my sheets would be named after the location (ie sheet 3 renamed as Aberdeen, sheet 4 Altrincham, sheet 5 would be Anniesland etc)

On worksheet 2 i would like a list of all locations. (And this next part is what I anticpate as being the tricky bit). My list of locations is ever expanding, and it would be great to just add a new location to the bottom of the list on Sheet 2, and have excel create a new worksheet with that name, and also for that location to appear in my list on sheet 1!

Now, I have no idea how hard this is to do. Ive tried severl template site, the MS help doesnt really help me, and I'm at a bit of a dead end.

View 12 Replies View Related

Copy Pull Down Menu From WS1 To All Other Worksheets?

Jun 3, 2014

How do I copy a Pull Down Menu from WS1 to all other Worksheets?

View 4 Replies View Related

Display And Print Orders' First Rows

Feb 10, 2009

There will be many orders in this list and each orders will have several appendixes. I want to able to see and print the orders with their first appendix row but I want to do that when I need.

and do not want to loose any data.

View 4 Replies View Related

Print Preview Display Of Range Very Slow

Jun 10, 2008

I have only one macro created in my excel workbook which is printing rows between two rows that their references are given.

To print-preview the results only takes 2 minutes, although it is only one page because I don't have much data in the spreadsheet yet. Also, to print it takes another minute.

How can the macro run and display results in less time?

View 7 Replies View Related

Print Only Certain Worksheets

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

Print All Worksheets As PDF

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

Disable Print For The Set Of Worksheets

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

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 View Related

Print Specifice Worksheets

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

Set Print Orientation On All Worksheets

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

Excel Camera Tool - Print Preview Different From Display On Screen

Nov 27, 2012

I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)

Problem Example.png

.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.

Problem Example_Print Preview.png

View 8 Replies View Related

Locking Print Areas On 7 Worksheets

Feb 27, 2013

I have locked print areas on 7 work sheets. I have successfully printed them at 1 time. However it appears as if the print areas have to be set again before I print them again? What's up.

View 2 Replies View Related

Print Multiple Pages And Worksheets To PDF?

Aug 25, 2013

In my excel, i have 3 worksheets. On the first worksheet, i have 2 pages since i have 2 sections side by side. I can't stack the sections due to different column widths. I am trying to see if there is a macro to stack the 2 pages on the first worksheet as one pdf page, and then have worksheets 2 and 3 as pages 2 and 3 of the pdf.

View 1 Replies View Related

Print Worksheets Based Upon Criteria

Oct 23, 2006

I have a monthly template that has 31 tabs labeled 1 through 31 for the days of the month. I would like to add a macro that would print only the sheets that have a value greater than 0 in either of two specific cells.

Example:

Sheet / Cell B2 / Cell B36 / Action
1 / 0.00 / 0.00 / Don't print
2 / 100.00 / 0.00 / Print
3 / 0.00 / 100.00 / Print
4 / 100.00 / 100.00 / Print

I could add a summary sheet that would pull over these values and/or add if statements that return results like "don't print" or "print" if it would be easier in the macro or I could just use the code in macro to determine to print or not.

I am a record and tweak macro user and this isn't something you can record. I found some simple code in another post that would print one page based upon single criteria but it isn't exactly what I was looking for.

View 9 Replies View Related

Userform To Print Visible Worksheets..

Sep 20, 2007

I have a form to allow users to select and print pages from a workbook.

Private Sub UserForm_Initialize()
Dim sht As Worksheet

For Each sht In ActiveWorkbook.Worksheets
ListBox1.AddItem sht.Name
Next sht
Me.Height = 128
End Sub

Only problem is that this lists all worksheets in the form. Need to modifying it so that it does not list worksheets that are xlSheetVeryHidden.

View 2 Replies View Related

Macro To Print Existing Worksheets

Feb 12, 2008

I'd like to create a macro that can access few existing worksheets from different workbooks and print them automatically when i press the button or select them.

Tried userform and listbox that were suggested from other thread, but that didnt work quite well since I'm not quite understand the code behind it.

View 9 Replies View Related

VBA Macro To Consolidate Several Worksheets Into One & Print

Apr 11, 2009

I used a Macro from here that creates one worksheet from several then prints and deletes it. However the Macro doesn't carry over my column/row size formats. Is there a fix?

View 2 Replies View Related

Print All Worksheets Before Specific Sheet

Apr 21, 2008

I am seeking the most efficient code to print all excel worksheets beginning with sheet "XYZ" and ending with the last sheet in the workbook.

- Sheet "XYZ" is always the starting point
- The number of sheets after "XYZ" is variable
- The names of the subsequent sheets are unique and not sequentially named/numbered
- The printing will be to one report (i.e. don't print pages individually)

View 2 Replies View Related

Print To Exclude Fill Colors On Worksheets

Oct 7, 2008

The bright colors work well, but when they print the sheet on a laserjet black/white printer, the colors make the data almost impossible to read.

Is there a way to allow them to print the sheets and, by default, not print the background fill colors?

View 3 Replies View Related

Print Specific Worksheets In Multiple Files To PDF

Aug 13, 2012

I'm trying to find a solution to print to PDF specific worksheets in multiple Excel files. The files reside in the same directory, and I would like to be able to print them all at once to PDFs.

View 3 Replies View Related

Setting Same Print Area And Settings Across All Worksheets?

Feb 2, 2014

Is it possible to set the same print area and print settings i.e. Landscape and 1 page tall by 2 pages wide, across all worksheets in an excel file? I have a file with 365 worksheets. They all have the exact same layout and need to be printed off daily. I can set the print settings every day manually but was wondering if there is an easy way to do them all in one go?

View 4 Replies View Related

Macro To Print Worksheets When A Cell Value Exceed Zero

Feb 21, 2007

a macro to print a series of worksheets only when a certain cell (probably would have to be a named cell as lines may be added to some of the worksheets at some stage) in that worksheet exceeds zero.

View 9 Replies View Related

Print Worksheets Based On Information In Column

Jun 1, 2006

I have a workbook with many sheets, all of which derive information from the first sheet. On the first sheet, I enter values from say J1:J29. Each of these values is fed into one of the subsequent worksheets. I would like to have some code that would look at my range, determine which cells are used and print the corresponding worksheets. Write now I have a bunch of If statements that say

If Sheets("Worksheet").Range("j8") > 0 Then
Sheets("698-ALY W1222").PrintOut
End If




the problem is that it takes to long as each statement is evaluated and the print command sent.

The values in column J have names in column I and while the names do not exactly match the worksheets, a person could look at the name and match the correct sheet. For instance the name in column I that corresponds to the worksheet name 698-ALY W1222 is 698/ALY.

Thanks
Bryce

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved