Thread: print zoom
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geebee geebee is offline
external usenet poster
 
Posts: 190
Default print zoom

hi,

i have the following:

ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="printer"


i would like to know how i can add a zoom number in this statement. I tried
ActiveWindow.SelectedSheets.PageSetup.Zoom = 60
ActiveWindow.SelectedSheets.PrintOut ActivePrinter:="printer"

but to no avail.. could someone please help?

thanks in advance,
geebee