How to set Print Properties in macro?

[AZSteve]

Using Excel 2003. I haven't been able to figure out how to program this
using commands or keystrokes >

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 in 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. 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

[Franz Verga]

Try to record a macro while setting the printing preference (menu Tools,
Macro, Record a new Macro: choose the Personal Workbook as storage for the
macro). Then with ALT + F11 you can open di Visual Basic Editor and check
and modify the code you recorded.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy (now in Berlin)