print defaults at 20 copies
I have a spreadsheet, with VB code. Everytime I go to print, the default
number of copies is 20. If I change this to 1, and then save, it still comes up as 20 the next time I go into the print menu. There is no VB code relating to printing. Can anyone help please? |
print defaults at 20 copies
this sounds like a printer driver issue, not an Excel issue
to check if it is an excel issue, open excel in safe mode and print a document. otherwise go to your printer control and check to see what it has as copies "KneeDown2Up" wrote: I have a spreadsheet, with VB code. Everytime I go to print, the default number of copies is 20. If I change this to 1, and then save, it still comes up as 20 the next time I go into the print menu. There is no VB code relating to printing. Can anyone help please? |
print defaults at 20 copies
additional questions
is this on all sheets or just one does it do this with a new book or just one if it is just one sheet right click on the tab and select view code there may be a macro on that sheet for before_print "bj" wrote: this sounds like a printer driver issue, not an Excel issue to check if it is an excel issue, open excel in safe mode and print a document. otherwise go to your printer control and check to see what it has as copies "KneeDown2Up" wrote: I have a spreadsheet, with VB code. Everytime I go to print, the default number of copies is 20. If I change this to 1, and then save, it still comes up as 20 the next time I go into the print menu. There is no VB code relating to printing. Can anyone help please? |
All times are GMT +1. The time now is 09:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com