Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Printing / December 2003

Tip: Looking for answers? Try searching our database.

setting default printer?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karl Thompson - 22 Dec 2003 13:13 GMT
Can we select a default printer on a template by template basis?

If so, how?

(I've tried selecting a printer and resaving the template, but when a new
workbook is created, it always selects the user's default printer.)

TIA,
Karl
Paul Cundle - 22 Dec 2003 17:44 GMT
I would have suggested the thing you've already tried, but it looks like
that wouldn't have worked ;)

What you could try is, for each template, write a short macro (as little as
one line of proper code) that you put in the ThisWorkbook object like this:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
   Application.ActivePrinter = "Canon Bubble-Jet BJC-4300 on LPT1:"
End Sub

The active printer won't change when you open the book but rather when the
user prints, so if they want to print to another printer there might be a
problem. The alternative is to use Workbook_Open instead of
Workbook_BeforePrint. This would change the printer on opening the file so
the user can choose another if desired, but I believe that if you created a
workbook with YourTemplate1 and then another with YourTemplate2, the printer
which is chosen by YourTemplate2 would then get used by default for both
files. This is probably unavoidable anyway, since Excel can only have one
printer active at a time.

HTH,
Paul C,
Signature


> Can we select a default printer on a template by template basis?
>
[quoted text clipped - 6 lines]
> TIA,
> Karl
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.