J,

Bingo. This worked fine. As you and Don suggested, intercepting the
Workbook_BeforePrint event accomplishes exactly what I asked for Thank You!.

You raise a couple of good points.

Maybe a better solution would be to create another custom button for the
toolbar that when pressed prints out the two ranges from the 2 sheets in
question. Is this even possible?

Or is there another way to idiot-proof the printing operation