Aloe all, here is my issue:
When we print an invoicing worksheet, we adjust the page breaks depending on how many days/shifts we need to cover and we reuse the same workbook as a template for the next one. So, if someone was using one that covered 7 days and the next one only covered 1 and they printed it without changing the page breaks, there would be a lot of wasted paper (and there is). I'd like to figure out how to make a pop up reminder initiate when someone hits the print button to check the page breaks.
I've found references to something called workbook_beforeprint, but I don't know how to use it. I just see people reference it as though it were a button on the ribbon.
If anyone could help with this, it would be much appreciated.
When we print an invoicing worksheet, we adjust the page breaks depending on how many days/shifts we need to cover and we reuse the same workbook as a template for the next one. So, if someone was using one that covered 7 days and the next one only covered 1 and they printed it without changing the page breaks, there would be a lot of wasted paper (and there is). I'd like to figure out how to make a pop up reminder initiate when someone hits the print button to check the page breaks.
I've found references to something called workbook_beforeprint, but I don't know how to use it. I just see people reference it as though it were a button on the ribbon.
If anyone could help with this, it would be much appreciated.
