ExcelBanter - excel print dialog

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - excel print dialog (https://www.excelbanter.com/excel-programming/284920-excel-print-dialog.html)

Ricky M. Medley

excel print dialog

I want to initiate the Excel Print Dialog...the same one when you press
Ctrl+P...from VBA.
Surely you don't have to reinvent the box from VBA...??
And what about other dialogs from the normal Excel environment?

thanks
ricky

Steve Yandl[_3_]

excel print dialog

Application.Dialogs(xlDialogPrint).Show

"Ricky M. Medley" wrote in message
...
I want to initiate the Excel Print Dialog...the same one when you press
Ctrl+P...from VBA.
Surely you don't have to reinvent the box from VBA...??
And what about other dialogs from the normal Excel environment?

thanks
ricky

Ricky M. Medley

excel print dialog

thankyou

"Steve Yandl" wrote in message
...
Application.Dialogs(xlDialogPrint).Show

"Ricky M. Medley" wrote in message
...
I want to initiate the Excel Print Dialog...the same one when you press
Ctrl+P...from VBA.
Surely you don't have to reinvent the box from VBA...??
And what about other dialogs from the normal Excel environment?

thanks
ricky

All times are GMT +1. The time now is 09:06 PM.