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 . |
All times are GMT +1. The time now is 11:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com