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


I need to send out a spreadsheet to users that will print at one remote
location which includes several print macros (making complicated selections).
If the default printer is changed while the spreadsheet is open this will
cause the spreadsheet to abort. We print to one remote location but we would
like away to change the default printer to the remote location without the
spreadsheet aborting.

Please help me resolve this issue.

Thanks,



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 411
Default Change Default Printer Causes Abort

What line of code is highlighted in yellow when the spreadsheet
aborts?


On Oct 30, 8:48 am, Joe K. <Joe wrote:
I need to send out a spreadsheet to users that will print at one remote
location which includes several print macros (making complicated selections).
If the default printer is changed while the spreadsheet is open this will
cause the spreadsheet to abort. We print to one remote location but we would
like away to change the default printer to the remote location without the
spreadsheet aborting.

Please help me resolve this issue.

Thanks,



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
Default settings for my printer in Excel change when Import workbo rickitoni Excel Discussion (Misc queries) 1 February 7th 09 06:46 PM
members on my network printer not able to print to default printer smeheut Excel Discussion (Misc queries) 0 June 18th 07 06:42 PM
How do I change default printer settings Vanessa Setting up and Configuration of Excel 2 September 3rd 06 12:16 AM
excel macro to automatically change default printer James Bromley Excel Discussion (Misc queries) 1 January 15th 06 11:42 AM
How do you change the default printer? DennisE Excel Programming 3 January 2nd 04 02:48 AM


All times are GMT +1. The time now is 01:18 PM.

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

About Us

"It's about Microsoft Excel"