ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Printing (https://www.excelbanter.com/excel-programming/402170-printing.html)

Greg B[_11_]

Printing
 
Hi,
I am wondering what code i would need to bring up the print selection box? I
mean the one where you can choose which printer and how many?

Thanks in advance

Greg



Mike H

Printing
 
Maybe

response = Application.Dialogs(xlDialogPrint).Show()

Mike

"Greg B" wrote:

Hi,
I am wondering what code i would need to bring up the print selection box? I
mean the one where you can choose which printer and how many?

Thanks in advance

Greg




Greg B[_11_]

Printing
 
Thanks for that

Greg
"Mike H" wrote in message
...
Maybe

response = Application.Dialogs(xlDialogPrint).Show()

Mike

"Greg B" wrote:

Hi,
I am wondering what code i would need to bring up the print selection
box? I
mean the one where you can choose which printer and how many?

Thanks in advance

Greg







All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com