automate printing different ranges on 1 worksheet at different tim

[SteveM]

I have an expense worksheet that contains different weeks. I want to print
each week's expenses on a separate page without having to set up a new print
range every time. This to allow the office person to print the new week's
expenses for processing.

[wjohnson]

Set-up a view you want, (i.e. hide rows and columns, etc.), jncluding having the "print area" defined. Then go on the menu bar go select "VIEWS" - then - "CUSTOM VIEWS" and follow the directions. As far as I know you can set as many different custom views as you want (depending on the limits of your machine and memory).

[SteveM]

OK, that worked. Thanks. Now the 2nd part: How do I create a button to
allow someone to print the given "view" without having to go to the views
dropdown menu?

"wjohnson" wrote:

>
> Set-up a view you want, (i.e. hide rows and columns, etc.), jncluding
> having the "print area" defined. Then go on the menu bar go select
> "VIEWS" - then - "CUSTOM VIEWS" and follow the directions. As far as I
> know you can set as many different custom views as you want (depending
> on the limits of your machine and memory).
>
>
> --
> wjohnson
> ------------------------------------------------------------------------
> wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
> View this thread: http://www.excelforum.com/showthread...hreadid=496166
>
>