oh! i do this all the time...... either to print one specific
worksheet or to print all the worksheets in a workbook.

you add a command button to the worksheet. check the properties &
change "print object" to false.

then add coding such as one of these:

Private Sub CommandButton1_Click()
Worksheets(1).PrintOut
'or Worksheets("Sheet1").PrintOut
End Sub


Private Sub CommandButton1_Click()
'will print them all........
Worksheets.PrintOut
'effectively de-selects the group of worksheets
'by just selecting one of them
Worksheets(1).Select
End Sub

:)
susan



On Jul 25, 2:46*pm, KenCanuck
wrote:
I can't figure this out. *I just want to add a 'button' next to some text,
that when clicked, will print a specific worksheet. *Thanks!