| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
go to worksheet on button name
I am trying to assign a macro to a button so that when clicked it opens the
worksheet whose name is on the button |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
go to worksheet on button name
Copy this event sub in the code window of worksheet containing the button:
Private Sub CommandButton1_Click() Worksheets(Me.CommandButton1.Caption).Select End Sub Regards, Stefi €˛Northern Dave€¯ ezt Ć*rta: I am trying to assign a macro to a button so that when clicked it opens the worksheet whose name is on the button |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i add a function button to a worksheet? | Excel Worksheet Functions | |||
| Moving a button on worksheet | Excel Worksheet Functions | |||
| How do I put a toolbar button into a worksheet? | Excel Worksheet Functions | |||
| How can I use the tab button after protecting the worksheet? | Excel Worksheet Functions | |||
| print different worksheet by pressing visible button on worksheet | Excel Worksheet Functions | |||
Linear Mode
