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,

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,