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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
How do I set a macro to unhide a worksheet and stay on it? 3
Excel crashes and restarts when accessing newly created worksheet 2
Customize Quick Access Toolbar 5
Userform to Select what worksheets to print 1
Macro that unhides a sheet and takes the user to that sheet 2
Change color of all option buttons in several worksheets 3
Button Click but not Shortcut Key 1

Back
Top