Print Control in Word/Excel
Sub ShowPrtDlgWord()
Application.Dialogs(wdDialogFilePrint).Show
End Sub
Sub ShowPrtDlgExcel()
Application.Dialogs(xlDialogPrint).Show
End Sub
-----Original Message-----
Hello
I want to place a 'Button' Control in Excel and Word
files.
I want the button to bring up the Print dialogue, just
the same way as going
to FILE -- Print would do
How do I do this?
Thank you
.
|