Repost cause I got no bytes on this earlier. Using Excel 2003. Network
printer/copier with lots of users, so many use a printer inbox to store their
documents until they go to the printer. I haven't been able to figure out
how to program this using commands, and Sendkeys only gets me so far

1. Select Print / Properties. Set output method to Store, acknowledge
message if it is being changed, and select User Inbox 3 (which already has my
name).

2. At same time, set Print Style to 2-sided Printing.

3. Then select the OK button so you go back to the Print box.

I can do this stuff as a computer default for all documents I generate, but
I want to be able to attach this to a macro button on my Personal template
for all the documents I get from others, because those documents print with
their settings (especially, to their printer inbox), not mine. Putting a
macro on a button is not the problem - it is the programming of the macro to
do 1, 2 and 3 that is the problem.