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


.