Thanks for all the relies your stars ******

"JLGWhiz" wrote in message
...
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