I would like to print a excel sheet and each time I print this sheet
a new number would be place on that printed sheet.
Like a invoce number.
So if I would print 50 sheets it could be number from 1 to 50 on each sheet
or if I printed 10 sheets it would be number from 1 to 10?
I have this question for indentifying the last row (number) for each and every page to be printed.
As I am using a loop to determine the last row of the table in each print page, I am only able to do in "hard coded". And with this "hard-coded" row number, I can set bordering to the table so that table will not be printed without any border (for in between pages if table is more than a page)
But the problem is that I had discovered that once any other user start using wrap text, or even change the row height, the macro will still captures the pre-determined no. of rows to do the bordering (as shown in my code).
In my, I had restricted the zoom size so that the quotation will always be the same format. Hence, based on this control zoom, the printable page changes if the row height changes too.
With destSh.PageSetup
.PrintArea = "$A1:$H" & LastR
.PrintTitleRows = "$1:$21"
.Zoom = 62
' .FitToPagesWide = 1
' .FitToPagesTall = 8
.PrintErrors = xlPrintErrorsDisplayed
.RightFooter = "&8Last Saved : " & _
Format(ThisWorkbook.BuiltinDocumentProperties("Last Save Time"), _
"yyyy-mmm-dd hh:mm:ss")
.CenterFooter = "Page &P of &N"...................
I would like to test for the number of pages that will be printed. Is there any way to do this with Excel VBA?
View 3 Replies View RelatedI have a excel file to print label on a label printer.I've added additional file in this message.I'm printing different numbers of labels with this file.for example, if I print 10 pieces of labels, I want to write 1/10 , 2/10 , 3/10 etc. on each label.I finded a vb code to print this work but not exactly the way I want.I would ask one of excel guru's to look at my file.
View 8 Replies View RelatedI have a selected area which I print as labels.
I want to have a number on this label preferably counting back from the quantity of print.
So if I select 300 copies to print, the first label shows somewhere 300, the 2nd label 299, the third 298 and so on.
I use a button and macro for printing selected labels, so perhaps the reverse printing could be added there if only counting up is available.
Also to make it easier, a cell on the sheet can contain the number to count down from (this is preferred on thinking about it) So I could then print 20 labels from 300 to 280 say.
I have a macro that prints all documents that are found in a directory, i was thinking that it should be possible to modify this macro to count both number of documents as well as the pages that are printed, and display the count once the documents are sent for printing.
The Code:
Start of Code:
Sub ListDocNamesInFolder()
Dim sMyDir As String
Dim sDocName As String
sMyDir = "C:My Documents"
sDocName = Dir(sMyDir & "*.DOC")
[Code] .......
In A1 I have the time (military h:mm) 8:00
In B1 I have the 30 min braek we take at work 0.30
in C1 the end of shift time (16:00)
In D1 total hours (formula : = sum(C1-A1)-B1
and it is OK EXCEPT if the employee has the day off.
In that case A1 and C1 are empty but because of B1 I get in D1 the terrible ####
How can I remedy this ... this sheet cannot be edited in anyway. ( I cannot delete or edit anything)
Thought of an IF but the #### are not a value so I cannot do much in the way of conditional fprmats ... how not to show these #### when the sheet is printed.
I need a method or function that can count the TOTAL number of pages to that will be printed. I don't need anything with HPageBreaks or Get.document(50, ""sheet name"")") for these don't seem to work on my worksheet.
All they seem to do is give me a number lower then the number of pages that will be printed and they are dependent on where the active cell is.
Here is my code that does not work.
Code:
Agreement_Page_Count = ExecuteExcel4Macro("Get.document(50,""Signature Page"")")
and
Code:
Function HowManyPagesBreaks(sSheet As Worksheet)
Dim iHpBreaks As Integer, iVBreaks As Integer
Dim iTotPages As Integer
With sSheet
[Code] ........
Both codes return 2 when there are 3 pages that can be printed. Unless I pause the code select the cell at the bottom of my sheet (it ignores it if I use use a macro to select the bottom cell) and then continue my code.
I've tried it with and without the entirerow.hidden.
Is there a way of bypassing everything and using a marco to open up page preview and getting the total number of page to be printed? I'm using excel 2010
I have a print macro that runs from a command button, when I use it the workbook goes to the sheet printed. Can I somehow make the workbook go back to a sheet of my choice? Here is the macro, The command button is on a sheet called Control Center, can I return to that sheet or stay at that sheet when I print?
Code:
Sub Button16_Click()
Sheets("OBS1").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub
I have data in different columns in the excel sheet which i want to use to print labels to be pasted on the envelops in the form of address.
For example : different columns are :
Dr.G.C.AgarwalC/o Sh V.K. Jain, 6/97, Kachora Bazar, BelanganjAGRA2820040562-22111399457003138
And I want the address as :
Dr.G.C.Agarwal
C/o Sh V.K. Jain, 6/97, Kachora Bazar, Belanganj
AGRA282004
0562-2211139
9457003138
In excel sheet some times I highlight Cells, Rows or Columns for references but while printing these highlights get printed. is there any formatting tip so that only values are printed but highlights don't get printed (not even in grey scale).
View 3 Replies View RelatedMy spreadsheet is a dual purpose spreadsheet, it is my printable catalog of product offerings as well as my worksheet for my cost and my cost markup. I have apx 2500 rows of product offerings.
My question -I would like to be able to print my catalog without my cost markup columns being printed. It is not practical for me to hide the column, then print, then unhide the column again every time I want to print out my catalog. I would like the columns to always be visible, but just not print.
if it is possible to have say 8 rows hidden, but when you print the page it prints the rows?
View 9 Replies View RelatedThe following code works fine except when the sheet1 gets printed then its blank but in actual the sheet1 has got some information in it. SO why its printing a blank page.
[Code] .....
Is there a way to 'lock' a page from being changed once it has been printed? It can be printed multiple times but want it to not be able to be edited once it has been printed. Thinking I could have a control button on the page maybe and once it has been checked ok to print then click the button and it saves it as is and uneditable?
View 3 Replies View RelatedWe have some reports on multiple worksheets. We need to ensure a legend/definition sheet is printed whenever one or several of the worksheets are printed. Is it possible to mandate a worksheet to be printed along w/ whatever else is being printed?
View 4 Replies View RelatedI have spent some time looking through the forum and even looked at Microsoft Excel help file and cannot seem to get exactly what I need. I have worksheets that I found the code on this site that I can put page breaks every so many rows. I have it set for 26 so it will break for every 25 counting the header. Here is the
Sub PageBreaks()
For I = 27 To 760 Step 25
ActiveSheet.HPageBreaks.Add Before:= Range("A" & I)
Next I
End Sub
The problem I am having is when I print the first page it has the headers in them, for example.
LastName, FirstName, StuID, GrdLvl
How can I get a row placed right after each page break with with the column headers so each sheet I print will have the headers with the 25 rows of informatio. But then not be there after I print so If I need to sort I won't have a problem with all the headers.
I have a worksheet which has two large tables. When one table flows onto another page, the users need to see the title i.e. Header of that table. How can I do this?
View 9 Replies View RelatedMany people use Excel to generate forms that will be printed off and carried around on a sheet of paper, because the boxes and lines are nice and square, and straight, Word is not so co-operative
There have been lots of queries how to auto-number such forms, so that you can later file or issue them in a particular order, or use the numbers later as a reference doing other stuff.
Here's what I want to do:
I run a limousine service taking clients from places like hotels to various destinations
I have a little travel voucher form, to be filled by hand, 3 copies to a sheet, so we are gonna print them, and cut the page into 3 lil vouchers. Like printing lottery or competition tickets. The vouchers have artwork to suit the place requesting my service.
They are NOT invoices, to be opened, numbered, worked on, and THEN printed
Cell G2 will start autonumbering at 1001, Cell G18 would be 1002, Cell G34 would be 1003, then when the second page prints, we get 1004, 1005, and 1006 respectively. Each sheet has to be individually cut and stacked
Alternately, we decide a quantity to print (50) and start G18 at say 1050 and G34 at 1101. This would be better, because when cutting the paper up with a guillotine, the first 50 vouchers are already in number order, the 2nd 50 get stacked under them, and finally the 3rd 50 below that, so now my stack of vouchers runs from 1001 to 1150 nice and easy and neat
A drawback with this is that I have to do specific print runs and somewhere in the document, specify the starting number for G2
I have heard of a method to print, say 20 forms, starting say, 1001, ending 1020 and a text file saves the last number used, so the next print run picks up from there, at 1021, can that method be combined in? I'm working in a small office that needs these vouchers but we dont wanna have a commercial printshop tool up (big $) to do small print runs
I can also do the vouchers for other suppliers to use with different artwork
I have a document that I need to track all changes to. I have a macro running perfectly right now that tracks all of the content changes to the form. What I am wondering is if I can add something that would also record when a copy is printed and the user that makes the copy. Here is the code I have right now:
Code:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.ScreenUpdating = False
Sheets("Revisions").Unprotect Password:="Hm72K9"
If ActiveSheet.Name = "Revisions" Then Exit Sub
Application.EnableEvents = False
[Code] .....
Would it be possible to have a unique number appear on every indivually printed sheet?
My worksheet in Excel fits onto one sheet of paper and I would like a unique number to appear whenever I print, even after closing system and re-opening file at a later date (the last printed sheet is 'remembered' so the next printed sheet is the next number in sequence).
So the first time I print a batch of say 100 I would have 100 x identical pages EACH with a unique number, i.e., '0001' to '0100'. The next time I print another 50 say, I would have '0101' to '0150' and so on.
Is there a way I can display the total of a column on each printed page?
I have a table which is about 6 columns long but is hundreds of rows down. I would like the total of one of these colums to be displayed on every printed page. Is this possible?
I make a lot of charts that have text boxes, or autoshapes in them. Often, the text boxes will be shifted in print preview. Even if they look right in print preview, they some times shift when being printed.
WYSIWYG, doesn't seem to apply
I've noticated that when viewing the spread sheet normally if I change the amount of zoom the text boxes/autoshapes will appear to move around, but what ever the position is for a given zoom amount, it will be same everytime.
Is there a "magic" zoom level that will display what will be printed, or are there some other tips to What-You-See-Is-What-You-Get in excel?
Cell 1A = Lot# Cell 1B = Last Name Cell 1C = First Name Cell 1D = Phone. I need Row1 to be repeated on each page. The list has about 200 names. We live in a senior community so the list changes quite often.
View 3 Replies View RelatedI am trying to print the file name as a header and the tab name as a footer automatically when i print an entire workbook. I am following the following steps:
File - Print - Entire Workbook - Preview
once I am in preview, I enter Page Setup and choose custom header (to print file name) and custom footer (to print sheet name). It works on some but not on all of them
is it possible to make row 1 the (headingline) top of every printable page? office excel 2007 by the way
View 3 Replies View RelatedAs you look in the the attacht file you can see that there are rows in grey. But if i print it everything is black. We tried on a differend computer (even differend opperating system) and on mac it prints correct, but on my windows it doesn't? It is probable a setting but i can't find what it is..
View 1 Replies View RelatedI have the following code to print a selection of data which is fine but i need to have in the code a different printer. So, for example my default printer needs to stay the same but when this spreadsheet is open i need the data to be printed to another printer.
View 3 Replies View RelatedMy company started using preprinted forms to print out delivery receipts with a dot matrix printer. We only need to print 2 pieces of data on this form at specific places, then move onto a new form and print the next 2 pieces of info. Ive tried searching and haven't found anything remotely related to this situation.
Essentially, we will have a spreadsheet with 2 columns with cells containing stock codes eg:
StockA1 StockB1
StockA2 StockB2
etc
The number of rows will vary, one week may be 20 rows of info, the next may be 76 rows.
I need to be able to take the info in each row, and send it to the printer so that it prints in the right place of the form, and move onto the next row/page until all rows have been printed.
Currently, I have a spreadsheet with a bunch of empty rows, 2 rows where the info needs to be, then more empty rows followed by the next 2 items, empty rows etcetc...As you can imagine this could require some tedious reworking week after week as the number of forms to be printed changes each week.
There has to be a better way to do this! I havent got the experience of working with excel (or dot matrix printers)
I am using a form textbox on a worksheet. I have the textbox positioned where I need it to be but when I print the worksheet the textbox moves out of position.