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

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