I would use the built-in constant

application.Dialogs(xldialogprint).show

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Stephen C" wrote in message
...
Application.Dialogs(9).Show

"lohme" wrote:

I have a macro that does some page formatting, prints the document, and
then
reformats the page. Now I have a designated printer but would like to
have
the ability to pick which printer I want to use then continue with the
reformating.

How do I do this??