Add print function
 

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.

Add print function
 

That's easy enough to do but you will have to furnish the sheet names to
print or the sheet names not to print. You would also have to furnish the
range to print in each sheet or some logic that Excel can use to find the
range to print. HTH Otto
"Tim" wrote in message
...
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.

Add print function
 

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.

Add print function
 

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.

Add print function
 

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.