Print preference changes when e-mailed - WHY
 

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!!!!

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!!!!

Print preference changes when e-mailed - WHY
 

just in case i don't get back here, this is a macro that will set the
page set-up, etc. you'd have to change the print area to what you
need it to be.

Public Sub Auto_open()

With ActiveSheet.PageSetup
.FitToPagesWide = 1
.FitToPagesTall = 1
End With

ActiveSheet.PageSetup.PrintArea = "$A$1:$AP$55"

End Sub

hope it helps!
susan


On Oct 20, 2:55*pm, Susan wrote:
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!!!!- Hide quoted text -

- Show quoted text -

Print preference changes when e-mailed - WHY
 

Hi,

The problem is at his end, use Page Setup on his computer to set the print
options.

--
Thanks,
Shane Devenshire


"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!!!!

Print preference changes when e-mailed - WHY
 

He said he has his page set up the same as mine but it will not carry over to
the next document he is working on. Any ideas??

"ShaneDevenshire" wrote:

Hi,

The problem is at his end, use Page Setup on his computer to set the print
options.

--
Thanks,
Shane Devenshire


"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!!!!