Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Change Printer

I am trying to print a workbook where each of the three
worksheets and or print ranges are printed to a different
printer. For example...

I set the print range of the first sheet to be printed.
So print range 1 goes to HP Printer 1.

The second print range goes to HP Printer 2.

These printer are setup on my pc.

Many Thanks,

Brady Snow
McKinney, Texas
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default Change Printer

Have you tried recording a macro while you do this manually.

"Brady Snow" wrote in message
...
I am trying to print a workbook where each of the three
worksheets and or print ranges are printed to a different
printer. For example...

I set the print range of the first sheet to be printed.
So print range 1 goes to HP Printer 1.

The second print range goes to HP Printer 2.

These printer are setup on my pc.

Many Thanks,

Brady Snow
McKinney, Texas



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
Change in Column Width depending on whether printer is installed / SLK Excel Discussion (Misc queries) 1 May 9th 08 05:53 PM
How to change the printer paper source for all worksheets in a wrk Joe Excel Discussion (Misc queries) 14 October 18th 07 10:43 PM
How do I change margins in Excel without a printer to my laptop? DRBoncze Excel Discussion (Misc queries) 2 September 4th 06 05:52 PM
How do I change default printer settings Vanessa Setting up and Configuration of Excel 2 September 3rd 06 12:16 AM
Excel Macro - change printer Samrcat Excel Discussion (Misc queries) 14 June 28th 06 05:47 PM


All times are GMT +1. The time now is 05:14 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"