View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Print macro to bring up print options

Use it without parentheses

ActiveSheet.PrintOut Preview:=True

"Nelly" wrote:

Hi probably a stupid question but did know how to do this. What macro do I
need to bring up the printer dialog box? I have one that just prints but
need to change paper type.

Thanks in advance
Nelly