My company is using Google Sheets to generate SKU labels. (Not like a mailing list. We generate labels one at a time on a Dymo printer.) I'm trying to automate the printing process to reduce click through time and errors. I want a macro(s) that prints one sheet (the Label) and then clears certain cells on another sheet (the Template).
When I Macro Record myself doing this as desired, Google Sheets does not record any of the print user interactions.
a) Why is this?
b) Is there a workaround that DOESN'T
involve generating a pdf?
c) Google Sheets remembers my print settings. Is there a way to see these "under the hood", meaning in Script? That way I can paste it in with my recorded macro...
For anybody else looking to reduce click through time, once you've established your print settings for the sheet keyboard:
1) [Ctrl] + [P] to call up the print preview
2) [Tab] to highlight the Next button then [Enter]
I wish Macro Record would record that but it does not -as of this writing.
Thank you for your precious time.