Thread: print to a user's default printer?

Hi all,

Is there a Macro to automatically print the selected print area (print area is also established within the macro itself) to a user's default printer; whatever that printer may be?

Note that this printer and/or printer name could change depending on the user.

I would like this to actually select and print to the default printer without Excel having to ask you. I don't even want the "OK" box to show up if possible. I just want them to run the macro, execute all it's duties, and print, all in 1 shot.

Can this be done? I'm using Excel 2003.

Thanks

Just use

Code:

ActiveSheet.PrintOut