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.
|