Thread: set up a pause in a print macro for user input
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default set up a pause in a print macro for user input
application.Dialogs(xlDialogPrint).show

--
Regards,
Tom Ogilvy

"Scott53" wrote in message
...
In creating a macro to print a section of the worksheet, I need to allow
the
user to select the printer location and number of copies desired.


Reply With QuoteReply With Quote