Control Zoom for Print Preview

S

scott56hannah

I have developed a report that is contained on a worksheet.

I am presenting that report to the user via a button on a form and the
PrintPreview view of that worksheet.

Unload NetWorthInspector_RunReports
Worksheets("ReportNetWorthDetailed").PrintPreview
Worksheets("ReportNetWorthDetailed").Visible = False
ActiveWindow.WindowState = xlMinimized
NetWorthInspector_RunReports.Show

Is there anyway to control the zoom on the resulting PrintPreview window
that is shown. At the moment there are only two (2) settings one is the page
on window and one slightly bigger....I want to be able to provide the user
with control to go as far as they want to increase the size of the report on
the window....

Thanks
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Preview Freezes 1
print button prints two images in same chart 0
BUG: print command from command button in userform causes double c 0
print command from command button in userform causes double chart 5
Not a 2nd print from the preview 0
Print Preview slows my code? 2
Print Preview XL2007 still not working properly 1
PrintPreview in I.E. ??? 2

Top