Hi Noscamou - sorry it's taken this long for a response but I only work part
time and have just got it this Mon morning. You may have sorted this out for
yourself already but the custom View would only contain print areas on the
one page (as far as I can work out) , it's the Report Manager Add-in that
allows you to set up a 'report', which is in essence a list of the Views and
their print areas, printing each one after the other. Just go to your addins
and make sure you have the Report Manager.
Hope this clairifies - yours Dika
"noscamou[ at ]gmail.com" wrote:
[Quoted Text] > Thanks Dika, this might work. But do you have to do this for each
> worksheet? Or can a custom view encompass print areas on different
> sheets within a workbook?
>
>
> Kernow Girl wrote:
> > Hi Noscamou - using excel 2002 the way I do it is to highlight the first
> > area I want to print, and set the Print Area, then go to Custom View and
> > create a new view.
> > Do the same wiht the second area, ie highlight, clear and then set this as
> > the print area, create a second Custom View. If you have the Report Manager
> > Add-In program you can then create a report to print all, some, different
> > orders, etc of the Custom Views. I have created quite complex 'reports' this
> > way
> > Hope this was what you were after ---- Dika
> > "noscamou[ at ]gmail.com" wrote:
> >
> > > I have a financial model with 12 months of 2006 data and 12 months of
> > > 2007 data side-by-side. I would like to print the 2006 data all the way
> > > down the sheet together (and there are several sheets like this) and
> > > then the 2007 data together. With all of the sheets I need to print, it
> > > is a painstaking process to set and reset the print area each time I
> > > want to print.
> > >
> > > Does anyone know of a way to automate this process using VB or a macro?
> > > I am not overly experienced in either of those methods.
> > >
> > > Thanks in advance.
> > >
> > >
>
>
|