View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pom pom is offline
external usenet poster
 
Posts: 7
Default VBA ActivePrinter

Hi all!

I need to send out a spreadsheet to users on different sites which has
several print macros included (making complicated selections). The document
has to be printed in colour - I set the macros up for my PC, using the path
to my colour printer. This will obviously be different for other users, and
the colour printer will not (generally) be their default printer. Before I
change the code completely, does anyone know a way of setting up an unknown
colour printer as your ActivePrinter?!

Cheers!