Macro Button

[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.

[Ron de Bruin]

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." <anonymous@discussions.microsoft.com> wrote in message news:00c001c507d1$0dac6b90$a601280a@phx.gbl...
>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.

[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

"T. R." <anonymous@discussions.microsoft.com> wrote in message
news:00c001c507d1$0dac6b90$a601280a@phx.gbl...
>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.