View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Tim is offline
external usenet poster
 
Posts: 408
Default 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.