Macro to set print default to 1 copy

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,522
I would like a macro to set the print default to 1 on the active sheet


If for eg. a user changes the print setting to print to 2 or more copies, I would like a macro to set this back to 1 after printing



your assistance in this regard is most appreciated
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

howard

Well-known Member
Joined
Jun 26, 2006
Messages
5,522
Found this code on the Net, but does not reset print copies to 1 in print preview

Code:
 Private Sub Workbook_BeforePrint(Cancel As Boolean)

Cancel = True

End Sub

It would be appreciated if someone can amend this
 

Watch MrExcel Video

Forum statistics

Threads
1,095,350
Messages
5,443,953
Members
405,258
Latest member
daveyf

This Week's Hot Topics

Top