| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
print scaling
hi,
i have the following: ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True is there a way i can amend this so that i can instruct to print at 80 percent of original size? thanks in advance, geebee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print scaling
Try:
ActiveWindow.SelectedSheets.PageSetup.Zoom = 80 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True I didn't test this so you might have to loop through the sheets to set the zoom. "geebee" wrote: hi, i have the following: ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True is there a way i can amend this so that i can instruct to print at 80 percent of original size? thanks in advance, geebee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print scaling
hi,
would this pretty much be the same syntax for Access VBA? ActiveWindow.SelectedSheets.PageSetup.Zoom = 80 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True how could i amend this to print an Access form? thanks in advance, geebee "JLGWhiz" wrote: Try: ActiveWindow.SelectedSheets.PageSetup.Zoom = 80 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True I didn't test this so you might have to loop through the sheets to set the zoom. "geebee" wrote: hi, i have the following: ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True is there a way i can amend this so that i can instruct to print at 80 percent of original size? thanks in advance, geebee |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
print scaling
I don't have Access, but one way to find out is to try it.
"geebee" wrote: hi, would this pretty much be the same syntax for Access VBA? ActiveWindow.SelectedSheets.PageSetup.Zoom = 80 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True how could i amend this to print an Access form? thanks in advance, geebee "JLGWhiz" wrote: Try: ActiveWindow.SelectedSheets.PageSetup.Zoom = 80 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True I didn't test this so you might have to loop through the sheets to set the zoom. "geebee" wrote: hi, i have the following: ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True is there a way i can amend this so that i can instruct to print at 80 percent of original size? thanks in advance, geebee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in a excel test, what is print scaling? | New Users to Excel | |||
| Can I adjust print scaling for multiple print areas on the same sh | Excel Discussion (Misc queries) | |||
| print preview different from screen when using page scaling | Excel Discussion (Misc queries) | |||
| Spreadsheet will not print out legibly even after scaling | Excel Worksheet Functions | |||
| print scaling | Excel Programming | |||
Linear Mode
