How can I set a worksheet to have a printer independent default number of copies other than "1" in the print [preview] dialog?
I have one worksheet in the workbook which people need to print 4 copies of, occasionally 3 or 5; highly unlikely to ever be one. I've tried suggestions I found on the web but they don't work for me. For example, "enter the print dialog and change the number of copies - Excel will remember" -- it doesn't remember beyond the workbook close nor if I change the selected printer.
I thought I could code something in the workbook_open sub to set a default which the user can change while they have the workbook open, but that the workbook reverts to my default when it's next opened. Something along the lines of ...
Activesheet.PageSetup.PrintCopies = 4 or Activesheet.PageSetup.Copies = 4
PS: Obviously these statements are wrong!
Is there any simple way to achieve this?
I have one worksheet in the workbook which people need to print 4 copies of, occasionally 3 or 5; highly unlikely to ever be one. I've tried suggestions I found on the web but they don't work for me. For example, "enter the print dialog and change the number of copies - Excel will remember" -- it doesn't remember beyond the workbook close nor if I change the selected printer.
I thought I could code something in the workbook_open sub to set a default which the user can change while they have the workbook open, but that the workbook reverts to my default when it's next opened. Something along the lines of ...
Activesheet.PageSetup.PrintCopies = 4 or Activesheet.PageSetup.Copies = 4
PS: Obviously these statements are wrong!
Is there any simple way to achieve this?
Last edited:
