N Northern Dave Nov 4, 2008 #1 I am trying to assign a macro to a button so that when clicked it opens the worksheet whose name is on the button
I am trying to assign a macro to a button so that when clicked it opens the worksheet whose name is on the button
S Stefi Nov 4, 2008 #2 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:
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:
