In Excel 2002, how do I create a button in my worksheet that will
print a different worksheet in the file?

Here's a comment

view toolbars control box
Click CommandButton
Drag to size
Right click view code


Enter 
Private Sub CommandButton1_Click()
    Sheets("Sheet2").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
End Sub


Sheet2 being the name of the tab

Hello omarkhanmr-ga,
Your suggestion worked well.  I'm curious if there is an easy way to
specify the area on the sheet to be printed.

Also, how do I wrap up this Google Answers Question since my question
is answered now?

Not all comments are posted by Google researchers. I think omarkhanmr
is not a Google researcher. Hence, your answer is free. I think you
can just "expire" it or "close it".

Also, you don't have to use a command button to create a macro button.
I find it much easier to just draw a textbox from the Drawing toolbar,
and right-click it and hit Assign Macro and choose the macro. :)

You can also record many macros. Here's how:

http://www.officearticles.com/excel/record_a_macro_in_microsoft_excel.htm

It seems one of the members of the site answered your question before
a reseacher could. You may want to expire or cancel your question
since it has already been answered. You may still be charged the .50
cent listing fee.
Nenna-GA
Google Answers Researcher