willianstein
New Member
- Joined
- Jul 10, 2015
- Messages
- 2
Hello everyone,
Every month I have to print multiple workbooks, each with several sheets, and since these workbooks are edited by my colleagues, each sheet often has its own Printer Preferences.
I need to print the whole work book at once (so I can use the printer stapler) and that I need to print the first sheet with different properties (first sheet must be blue paper and the rest white) than the remaining sheets (which means saving workbook as PDF is not an option).
I am aware that I can change each sheet individually, which is what I have been doing, but it is quite frustrating given the amount of sheets I need to change.
Basically, I was wondering if there is any functionality or VBA code that I can use to reset a sheet to the default printer properties more easily?
Thanks and Kind Regards,
Every month I have to print multiple workbooks, each with several sheets, and since these workbooks are edited by my colleagues, each sheet often has its own Printer Preferences.
I need to print the whole work book at once (so I can use the printer stapler) and that I need to print the first sheet with different properties (first sheet must be blue paper and the rest white) than the remaining sheets (which means saving workbook as PDF is not an option).
I am aware that I can change each sheet individually, which is what I have been doing, but it is quite frustrating given the amount of sheets I need to change.
Basically, I was wondering if there is any functionality or VBA code that I can use to reset a sheet to the default printer properties more easily?
Thanks and Kind Regards,
