Macro Button

T

T. R.

I have an workbook with 31 sheets (one for each day of the
month) I would like to create a print macro with a
corresponding button.

Is there a way to use only one button and depending on the
sheet that I am currently on, only print the range on that
specific sheet?

Thanks in advance.

T.R.
 
O

Otto Moehrbach

T.R.
In your macro, don't refer to any sheet name. Simply provide the range to
print and issue a print command. The code will print that range on the
active sheet. HTH Otto
 
Top