Thread: Print macro to bring up print options
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don[_30_] Don[_30_] is offline
external usenet poster
  
Posts: 20
Default Print macro to bring up print options
On May 13, 2:06*pm, "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

Application.Dialogs(xlDialogPrint).Show
Reply With QuoteReply With Quote