You can probably do what you want with:

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