Print Control in Word/Excel

[Ravi]

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

 

[Jonathan West]

Hi Ravi

In Word this is fairly straightforward. I'm assuming you want to put a
button on a toolbar. Go to Tools, Customize. Select All Commands from the
Categories list, and then FilePrint from the Commands list. Drag the command
to the toolbar you want it placed on.

In Excel, the process it similar. Go to Tools, Customize. Select File from
the Categories list, and then "Print..." from the Commands list. Drag the
command to the toolbar you want it placed on.

 

[Dave Peterson]

In excel, you can assign your button code like this:

Option Explicit
Sub testme()
Application.Dialogs(xlDialogPrint).Show
End Sub