View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Print preference changes when e-mailed - WHY

have you looked at the document as it arrives at his end (if
possible)?? is it still set on 1x1 wide setting? has the print area
changed? maybe his printer defaults are different.........
all i can suggest is a macro that will set those settings on his end
(if he doesn't know how) but he will have to click the button to set
them......... or you could make them automatically set up on an
auto_open macro.
but then again some email programs remove macros.
write back if you want to try an auto_open macro!
:)
susan


On Oct 20, 1:58*pm, Ronda wrote:
I have an excel 2003 document that we have used for years. Boss got a new
computer and every time I send it to him on his end it prints on 2 pages. I
have tries the fit to 1 page wide wide by one page wide and also set the
print area. Both work on my end but when I e-mail it to him it will print on
2 pages, HELP BEFORE I GET FIRED!!!!