View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James Bromley
 
Posts: n/a
Default excel macro to automatically change default printer

I need a macro to change the default printer to another selected preselected
printer.
I can get a workbook to do this but only after its been opened and then
re-run the macro.
this is to automate a workbook that has to be printed out on one type of
printer only and the users that will have it are not the sharpest biters in
the food chain!!