Print preference changes when e-mailed - WHY

[Ronda]

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

 

[Susan]

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

 

[Susan]

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

 

[ShaneDevenshire]

Hi,

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

 

[Ronda]

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