You may want to add a printer (different name) using the same printer but
with a different setup

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AZSteve" wrote in message
...
At work a network printer is the default destination, which I have set up
to
default to print 2-sided to a Store destination, mailbox 3 on the printer.
Documents I create print just fine, but I get many from others at work
that I
have to manually change to print that way. I want to do this with just a
click of a button on my Excel menu bar (once I have the macro, that is no
problem).

I can't figure out how to do via a macro what I do manually through Print
Preferences set the destination to Store and choose Mailbox 3 if that is
not already chosen, select 2-sided printing, if not already, then return
to
the Print box where I will manually choose the number of copies and hit OK
to
print.

I can't find or figure out if there are Excel VBA commands for this, and
Sendkeys only gets me part way there. At 20 or more times a day doing
this
manually, any programming help would be greatly appreciated.