saved printer settings in excel

[Jerry Rankin]

I have 2 printers that are alike and I want to be able to change printers
back and forth from time to time without losing my saved printer settings.
Is this possible?

[Doug Kanter]

Notice that if you click File, Print, and switch printers in the list, the
Cancel button for the dialog box changes to "Close". Record a macro as you
select each printer and click Close. Now, attach each macro to a custom
button on the toolbar. The only thing I don't know is whether the macro will
pick up printer settings which may be "non-generic" - particular to each
specific printer, in other words. You'll have to experiment to find out.

"Jerry Rankin" <Jerry Rankin@discussions.microsoft.com> wrote in message
news:D39C330A-635B-4F55-B3B7-FE5DCFBCBB23@microsoft.com...
>I have 2 printers that are alike and I want to be able to change printers
> back and forth from time to time without losing my saved printer settings.
> Is this possible?

[Jerry Rankin]

This did not save the tray source.

"Doug Kanter" wrote:

> Notice that if you click File, Print, and switch printers in the list, the
> Cancel button for the dialog box changes to "Close". Record a macro as you
> select each printer and click Close. Now, attach each macro to a custom
> button on the toolbar. The only thing I don't know is whether the macro will
> pick up printer settings which may be "non-generic" - particular to each
> specific printer, in other words. You'll have to experiment to find out.
>
> "Jerry Rankin" <Jerry Rankin@discussions.microsoft.com> wrote in message
> news:D39C330A-635B-4F55-B3B7-FE5DCFBCBB23@microsoft.com...
> >I have 2 printers that are alike and I want to be able to change printers
> > back and forth from time to time without losing my saved printer settings.
> > Is this possible?
>
>
>

[Doug Kanter]

What brand & model of printer? I have an idea that's got a 10% chance of
working. If it does, I want a case of Heineken delivered. :-)

"Jerry Rankin" <JerryRankin@discussions.microsoft.com> wrote in message
news:C0EEE81D-23B6-4B71-99D6-A34EEAFDA753@microsoft.com...
> This did not save the tray source.
>
> "Doug Kanter" wrote:
>
>> Notice that if you click File, Print, and switch printers in the list,
>> the
>> Cancel button for the dialog box changes to "Close". Record a macro as
>> you
>> select each printer and click Close. Now, attach each macro to a custom
>> button on the toolbar. The only thing I don't know is whether the macro
>> will
>> pick up printer settings which may be "non-generic" - particular to each
>> specific printer, in other words. You'll have to experiment to find out.
>>
>> "Jerry Rankin" <Jerry Rankin@discussions.microsoft.com> wrote in message
>> news:D39C330A-635B-4F55-B3B7-FE5DCFBCBB23@microsoft.com...
>> >I have 2 printers that are alike and I want to be able to change
>> >printers
>> > back and forth from time to time without losing my saved printer
>> > settings.
>> > Is this possible?
>>
>>
>>

[Doug Kanter]

One more question: Is the tray source a choice you use for ALL printing from
Windows, or just from Excel & certain sheets?

"Jerry Rankin" <JerryRankin@discussions.microsoft.com> wrote in message
news:C0EEE81D-23B6-4B71-99D6-A34EEAFDA753@microsoft.com...
> This did not save the tray source.
>
> "Doug Kanter" wrote:
>
>> Notice that if you click File, Print, and switch printers in the list,
>> the
>> Cancel button for the dialog box changes to "Close". Record a macro as
>> you
>> select each printer and click Close. Now, attach each macro to a custom
>> button on the toolbar. The only thing I don't know is whether the macro
>> will
>> pick up printer settings which may be "non-generic" - particular to each
>> specific printer, in other words. You'll have to experiment to find out.
>>
>> "Jerry Rankin" <Jerry Rankin@discussions.microsoft.com> wrote in message
>> news:D39C330A-635B-4F55-B3B7-FE5DCFBCBB23@microsoft.com...
>> >I have 2 printers that are alike and I want to be able to change
>> >printers
>> > back and forth from time to time without losing my saved printer
>> > settings.
>> > Is this possible?
>>
>>
>>