Contolling print output from Report Manager

G

Grim_up_North

Hi,

I've setup a simple accounts workbook for someone running a smal
business. Each one of 52 sheets representing 52 weeks of the year
There are four tables on each sheet each associated with a custom view
Each week/sheet has a "Report Manager" set for it to print out the fou
custom views for that week.

My problem is that because Report Manager circumvents Print Manager
there does not appear to be a way to control the way it prints thes
four tables out. I would like to set it to print 1 page wide by 4 page
tall if possible or even set a percentage on the size of th
print-out.

Is this possible.

Many thanks

Edga
 
S

Simon Shaw

I am not sure if this will work with Report Manager, but using a macro you can control the Page Setup. To see the various options, record a macro while adjusting the various settings in your Page Setup. To acheive a zoom you can use something like the following

With ws.PageSetu
.Zoom = 8
end wit
 
Top