#1
|
|||
|
|||
Printing Issue with Excel 2010
I am creating a document in excel for client use. In the header and footer I have inserted a jpg of a line (to outline the header and footer - strictly for asthetic reasons). However, when I print the document, the text in the document becomes all .. unsharp. Almost like a copy of a copy of a copy. When I remove the jpg of the line, the text sharpens right up.
I have tried the following: -using the underling/dash key to create a line - this has too many characters and is not allowed -Inserting a "line shape" into the header and footer - this is not allowed by the system, the shape can only be inserted into the main document. Any suggestions? |
#2
|
|||
|
|||
Hi
Please see a post below made by Tom Urtis a few years ago which may give you what you want. Tony Headers and footers are left, center, and right. Yes, they can be underlined. To do it, use the U& syntax. Here is an example of formatting the left header with the workbook name, the center header with some special manual notation, and the right header custom formatted for date and time. With ActiveSheet.PageSetup .LeftHeader = "&""Arial,regular""&U" & ThisWorkbook.Name .CenterHeader = "&""Arial,regular""&U" & "Budget sheet 1 of 10" .RightHeader = "&""Arial,regular""&U" & "Printed on " & Format(Now(), "mm/dd/yy, at hh:mm:ss") End With Regarding having the line stretch all the way across, one possible code line modification to do that would be to add spaces between quote marks, as in this example for the left header: .LeftHeader = "&""Arial,regular""&U" & ThisWorkbook.Name & " " You'd need to play around with it but that'd be the gist. __________________ Tom Urtis |
#3
|
|||
|
|||
Thanks!
This looks helpful, but I'm not sure WHERE to put that code. Any suggestions?
|
#4
|
|||
|
|||
Wait..
This is in Visual Basic, yes?
|
#5
|
|||
|
|||
Hi Amyrlin
Yes it is VBA. You need to create a new macro and paste the code between the Sub and End Sub lines. Tony |
Tags |
jpg, printing |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Issue When Using A Table | kiwi | Word Tables | 12 | 11-14-2011 05:21 AM |
MS Word 2010 printing!! | Collier | Word | 1 | 05-16-2011 12:13 AM |
Powerpoint printing issue | eidius | PowerPoint | 1 | 01-13-2011 07:38 AM |
Printing Question in Publisher 2010 | neojawbreaker | Publisher | 0 | 08-24-2010 05:35 PM |
New to Word 2010 and I need to tweak it for printing | Bobosmite | Word | 1 | 07-01-2010 11:31 AM |