Hello Tech Support,

I am writing a macro in excel 2003:

1. What command my macro that will allow the print icon to come up without
out having to use activesheet.printview? Currently the printview will be
displayed. Then I have to select the print button before I can select the
name of the printer I want.
2. Currently I have to ask the user to enter in a cell in excel an A for
Adobe PDF print format or P for a local printer so that my macro will use the
correct setup for the printview. I want to know is there macro code that
will identify the default printer or the type of printer you selected in the
print icon without having to enter the name of the printer in a cell.

Thank you for your help.

Rene