| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Copies for worksheet defaults to 5 incorrectly
Hi Folks
I Have a workbook that contains many worksheets. When trying to print the sheets, the Number of copies setting defaults to 1 for each sheet except 1 sheet which defaults to 5. If it is changed to 1 that's fine for that print but it then defaults to 5 again afterwards. There is no VBA in the workbook. The printer is not set to default to 5. The print driver is fine. Can anyone explain why this is happening and where this sheet is taking its default copies of 5 from? TIA Stuart |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Number of Copies for worksheet defaults to 5 incorrectly
filepagesetuppageoptionslayout
-- Don Guillett SalesAid Software wrote in message oups.com... Hi Folks I Have a workbook that contains many worksheets. When trying to print the sheets, the Number of copies setting defaults to 1 for each sheet except 1 sheet which defaults to 5. If it is changed to 1 that's fine for that print but it then defaults to 5 again afterwards. There is no VBA in the workbook. The printer is not set to default to 5. The print driver is fine. Can anyone explain why this is happening and where this sheet is taking its default copies of 5 from? TIA Stuart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print number of copies | Excel Discussion (Misc queries) | |||
| Print number of copies | Excel Discussion (Misc queries) | |||
| Workbook Defaults to Printing 33 Copies | Excel Discussion (Misc queries) | |||
| Printing defaults to more copies! | Excel Discussion (Misc queries) | |||
| Custom number format always defaults last number to 0. | Excel Discussion (Misc queries) | |||
Linear Mode
