Selecting Worksheet then running macro based on selected worksheet

What I am trying to do is create a print routine that will know which is selected and then print according the the selected sheet. There must be a way to write a looping function to say If Quickie Board (#) is selected then print Auction Report (#) and PICKNPAY (#).

Here is a copy of what I am trying to do...any suggestions?

Please Login or Register  to view this content.

How does this one work for you?

Please Login or Register  to view this content.