Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 24th 08, 11:55 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1
Default setting the default printer for this workbook only

i cant figure out how to set and ar save a particular workbook so that only
that workbook prints to a printer that is not my default printer. i woudl
like to keep it like this so i dont have to go and change the printer in the
primnt menue everytime i print. can anyone help me ?

  #2   Report Post  
Old October 25th 08, 01:47 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 2,344
Default setting the default printer for this workbook only

Hi,

Excel does not support a feature such as this, although you might be able to
program it.

It would look something like this

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Application.ActivePrinter = "Microsoft Office Document Image Writer
on Ne01:"
End Sub

To do this you need to record the macro, turn on the recorder - Tools,
Macros, Record new macro, leave the default name, make sure it is Storing to
This workbook.
After you click OK, choose File, Print and either pick the Name from the
list or choose Find Printer...
Eventually click OK to print and then Stop the Recorder - choose Tools,
Macros, Stop recorder.

The code needs to go into the thisWorkbook_BeforePrint macro. Press
Alt+F11, in the Project window at the top left find your workbook's name and
under it the item called thisWorkbook, double-click it and enter the lines of
code I gave you but put you code between the Sub and End Sub lines. Your
code will be in a folder under your filename in the project window called
Modules, in that folder double-click Module 1 and copy the line that looks
like mine from between the Sub and the End Sub lines, paste it in the
thisWork code we just entered.


If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


"mikecoxffbb" wrote:

i cant figure out how to set and ar save a particular workbook so that only
that workbook prints to a printer that is not my default printer. i woudl
like to keep it like this so i dont have to go and change the printer in the
primnt menue everytime i print. can anyone help me ?



Reply
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
members on my network printer not able to print to default printer smeheut Excel Discussion (Misc queries) 0 June 18th 07 06:42 PM
Default printer setting John Excel Discussion (Misc queries) 1 March 22nd 07 03:20 PM
Formatting Printer setting in a Macro rojobrown Excel Worksheet Functions 0 March 14th 07 08:02 PM
Printer Multiple Worksheets with a particular Printer Setting PP[_2_] Excel Worksheet Functions 0 March 14th 07 02:02 PM
Setting default pivot table field setting to "sum" Mr. Moose Excel Discussion (Misc queries) 2 December 21st 04 04:43 PM


All times are GMT +1. The time now is 05:32 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017