Thread: changing Print Preview default value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
anny anny is offline
external usenet poster
  
Posts: 23
Default changing Print Preview default value
thankyou
anny

"Norman Jones" wrote in message
...
Hi Giselle,

Try:

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


---
Regards,
Norman


Reply With QuoteReply With Quote