how to creat shortcut button to switching between worksheets?

  • Thread starter Thread starter kclau
  • Start date Start date
K

kclau

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)
 
Back
Top