Sub Switch()
If Worksheets.Name = "Master" Then
Worksheets("Some Other").Activate
Else
Worksheets("Master).Activate
End If
End Sub

print is just

Activesheet.Printout

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"kclau" wrote in message
...
I would like to add a button on the worksheet to switching between
different
worksheets. Also like to add a "print" button on the active sheet as well.
Please help!
Thanks All