I need to have a macro that will select multiple sheets based upon the value of a range and then print the selected sheets.
There are four Sheets:
Sheet 1 will always be selected in this macro
Sheets 2-4 need to be selected if SUM of Range in each sheet (B8:B500) is > 0
Once all of the sheets are selected I need it to issue a print (ctrl-p).
My users will then complete the printing process manually.