View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.office.developer.vba
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default query: print dialog with entire workbook set

sheets.select
application.Dialogs(xlDialogPrint).Show

--
Regards,
Tom Ogilvy


"KevinGPO" wrote in message
...
How can I write a macro to display/show the print dialog box/window, but
with Entire Workbook selected?