Thread: Newbie he I have a question about a print macro I am trying to write...
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Newbie he I have a question about a print macro I am trying to write...
You can use this maybe ?

Application.Dialogs(xlDialogPrinterSetup).Show
ActiveSheet.PrintOut

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kyaba" wrote in message ups.com...
Thanks for the Help Ron. I just have another quick question.

ActiveWindow.SelectedSheets.PrintOut From:=2, To:=2, Copies:=1, _
ActivePrinter:="\\svnydc03\Canon iR C3220 PCL5c on Ne02:",
Collate:=True
Sheets("2006 Actual").Select

what syntax can I use to make the activeprinter non specific so that
any user can print to whatever default printer they have available?



Reply With QuoteReply With Quote