Button on a sheet?

ViewToolbarsForms.

Select the button icon then draw a button on your sheet.

Right-click and "Assign Macro"

Button on a Toolbar?

ViewToolbarsCustomizeCommands.

Scroll down to "Macros" and select.

Drag a Smiley face up to a Toolbar then right-click on it and assign the
macro to that.

You can change the Smiley to another Icon should you wish and change the
Tooltip name also.


Gord

On Thu, 1 Jan 2009 16:35:01 -0800, Tim
wrote:

Gord,

I will always print the same sheets. How do I add a button and then put the
macro on it?

Thanks!!

"Gord Dibben" wrote:

Might be just as easy to CTRL + Click on the sheet tabs to print and
FilePrintActive Sheets.

Or a short macro on a button.

Sub Print_Selected()
ActiveWindow.SelectedSheets.PrintOut
End Sub

If you will always be printing the same sheets go with this.

Sub print_some()
ActiveWorkbook.Worksheets(Array("Sheet1", _
"Sheet4", "Sheet5")).PrintOut
End Sub


Gord Dibben MS Excel MVP

On Thu, 1 Jan 2009 14:13:00 -0800, Tim
wrote:

I would like to add a print button/link right on my worksheet that will print
some of my sheets but not all in the workbook. Any help would be appreciated.