LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
select printer macro jatman Excel Worksheet Functions 1 March 15th 08 01:58 PM
how doI set a macro to use with the printer? tiburon33 Excel Discussion (Misc queries) 2 December 6th 07 05:44 PM
Selecting printer in a macro lohme Excel Discussion (Misc queries) 4 January 2nd 07 06:36 PM
Selecting a printer Robin Clay[_3_] Excel Programming 0 February 2nd 04 06:25 PM
Selecting a Printer in VBA Robin Clay[_3_] Excel Programming 3 January 28th 04 01:13 AM


All times are GMT +1. The time now is 03:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"