Sub kl()
prtSetUp = Application.Dialogs(xlDialogPrintPreview).Show
End Sub


"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