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

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" <(E-Mail Removed)> wrote in message
news:CAE5B716-D680-41A9-B506-(E-Mail Removed)...
>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