Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a file created by another user that is defaulting to print 7 copies
instead of 1. How can I change this default back for this file only? Thank you! |
#2
![]() |
|||
|
|||
![]()
You might find something under Page Setup, Options. This varies with the
printer driver but in my case I found the copies controlled under Advanced options for my driver. -- Jim "Brenda" wrote in message ... |I have a file created by another user that is defaulting to print 7 copies | instead of 1. How can I change this default back for this file only? | Thank you! |
#3
![]() |
|||
|
|||
![]()
Thank you very much - that is exactly what I needed!!
"Jim Rech" wrote: You might find something under Page Setup, Options. This varies with the printer driver but in my case I found the copies controlled under Advanced options for my driver. -- Jim "Brenda" wrote in message ... |I have a file created by another user that is defaulting to print 7 copies | instead of 1. How can I change this default back for this file only? | Thank you! |
#4
![]() |
|||
|
|||
![]()
I assume this file contains macros?
Sub PrintSheets() ActiveWindow.PrintOut Copies:=1 End Sub If it does, look for code similiar to the bit above, it may or may not say copies, but look to see if anywhere in the same line as the .PrintOut there is 7. That is quite possibly the cause. Quote:
__________________
Justin Labenne www.jlxl.net |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change default measurements from cm to inches | Setting up and Configuration of Excel | |||
How do I change default font for all new comments in Office 2003? | Excel Discussion (Misc queries) | |||
[Excel] How do I change the default import external data settings. | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
How can I change the default 'comma' format. Eg paranthesis inste. | Excel Discussion (Misc queries) |