Create Macro Button to print sheet in Excel 2010

[lawitcher1]

I want to make a button in a sheet that will activate a Macro that will print the sheet. I came across this code:

Sub Macro1()
Application.Dialogs(xlDialogPrint).Show
End Sub

but cannot figure how to make the associated button in the sheet. Please advise

[NoSparks]

On the Developer Ribbon, click Insert, click the Form Control Button, outline on the sheet where you want the button.
You then get a dialogue giving three options:
New -> you can type or paste in the macro you want
Record -> Excel will build the macro for you as you perform what you want to happen
or you can pick from the list of existing macros.

Don't have the Developer Ribbon ?
see this