Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2011, 07:09 AM
Amyrlin Amyrlin is offline Printing Issue with Excel 2010 Windows XP Printing Issue with Excel 2010 Office 2010 32bit
Novice
Printing Issue with Excel 2010
 
Join Date: May 2011
Posts: 3
Amyrlin is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 05-11-2011, 12:38 PM
OTPM OTPM is offline Printing Issue with Excel 2010 Windows 7 32bit Printing Issue with Excel 2010 Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 05-16-2011, 07:18 AM
Amyrlin Amyrlin is offline Printing Issue with Excel 2010 Windows XP Printing Issue with Excel 2010 Office 2010 32bit
Novice
Printing Issue with Excel 2010
 
Join Date: May 2011
Posts: 3
Amyrlin is on a distinguished road
Default Thanks!

This looks helpful, but I'm not sure WHERE to put that code. Any suggestions?
Reply With Quote
  #4  
Old 05-16-2011, 07:46 AM
Amyrlin Amyrlin is offline Printing Issue with Excel 2010 Windows XP Printing Issue with Excel 2010 Office 2010 32bit
Novice
Printing Issue with Excel 2010
 
Join Date: May 2011
Posts: 3
Amyrlin is on a distinguished road
Default Wait..

This is in Visual Basic, yes?
Reply With Quote
  #5  
Old 05-16-2011, 09:56 AM
OTPM OTPM is offline Printing Issue with Excel 2010 Windows 7 32bit Printing Issue with Excel 2010 Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Quote:
Originally Posted by Amyrlin View Post
This is in Visual Basic, yes?
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
Reply With Quote
Reply

Tags
jpg, printing

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing Issue with Excel 2010 Printing Issue When Using A Table kiwi Word Tables 12 11-14-2011 05:21 AM
Printing Issue with Excel 2010 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
Printing Issue with Excel 2010 New to Word 2010 and I need to tweak it for printing Bobosmite Word 1 07-01-2010 11:31 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 08:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft