Selecting printer in a macro
thanks...worked great!
"Bob Phillips" wrote:
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??
|