Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
printing preference | Excel Discussion (Misc queries) | |||
Print defaults for e-mailed file | Excel Discussion (Misc queries) | |||
Assigning people to places based on rank and preference | Excel Discussion (Misc queries) | |||
how to disable ms exchange as email preference | Excel Discussion (Misc queries) | |||
Search and Replace: set user preference? | Excel Discussion (Misc queries) |