View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BrianG[_4_] BrianG[_4_] is offline
external usenet poster
 
Posts: 23
Default Selecting printer from macro

I have a form which prints using the PrintOut method. This prints to
the default printer. I have users who will change their default printer
to our plotter or inkjet printer whose limited print area affects the
form. Changing the ActivePrinter from within the macro is a problem
because the printer name is not consistent on all PC's. Is there a way,
from within the macro, to prompt the user to select the appropriate
printer?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!