View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Giselle[_2_] Giselle[_2_] is offline
external usenet poster
 
Posts: 22
Default changing Print Preview default value

hello to all

I have shown a code fragment that shows a report in Print preview mode.

With Worksheets("PrintRpts")
.PrintOut copies:=PrintNumber, preview:=PrntPrev
End With

My sub is used to show many such previews in sequence. Typically I give a
quick inspection, then Print the copy. The preview displays properly, but
the 'zoom' button is always highlighted by default. How can I use code to
have the 'Print...' button highlighted by default.

Giselle