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,

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


On Oct 30, 8:48 am, Joe K. <Joe K...@discussions.microsoft.com> 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,