Print macro to bring up print options
 

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

Print macro to bring up print options
 

Application.Dialogs(xlDialogPrint).Show

Very rarely is a question "stupid".

This is not one of those rarely's


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 20:05:48 +0100, "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