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.

Hi

Here are some one liners that you can use
http://www.rondebruin.nl/print.htm#Print


--
Regards Ron de Bruin
http://www.rondebruin.nl



"T. R." wrote in message ...
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.

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

"T. R." wrote in message
...
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.