chrisnosleep
New Member
- Joined
- Nov 18, 2018
- Messages
- 2
Hi all,
This is my first post. First, thank you for reading. Second, I'm an average user of Excel, but completely new at macro's and VBA. I've searched around for days looking for an answer to this question, but haven't found anything that works yet.
I know its simple enough to click and change, but we all forget from time to time. We're printing to a label printer, and although it works, it doesn't like being set to collated. The file is used among several users on several PC's. There are 3 shifts, and they all share the PC's.
I'm looking for a way to automatically set the print setting to uncollated each time the file is opened. Unfortunately the print driver itself doesn't contain a collate option, so it has to be done in Excel's print settings. Can anyone help with this?
Thank you in advance!
This is my first post. First, thank you for reading. Second, I'm an average user of Excel, but completely new at macro's and VBA. I've searched around for days looking for an answer to this question, but haven't found anything that works yet.
I know its simple enough to click and change, but we all forget from time to time. We're printing to a label printer, and although it works, it doesn't like being set to collated. The file is used among several users on several PC's. There are 3 shifts, and they all share the PC's.
I'm looking for a way to automatically set the print setting to uncollated each time the file is opened. Unfortunately the print driver itself doesn't contain a collate option, so it has to be done in Excel's print settings. Can anyone help with this?
Thank you in advance!
