I have a print macro set up so that when the user pushes the "Print" button on the "Input" tab, it prints a selected range ("A1:I272") off of the "Output" tab. It prints 6 sheets as that is the range that is selected, but the way I have it set up (in regards to print area) is that each page contains information that may or may not be relevant and need to be printed.

Is there a way to set up the macro so that when the user presses the "Print" button, a check box comes up and ask the user what all they need printed (6 selections) so that it will only print what is valuable to them at that time?


Thank you!