Hi
Basically i need to have 2 buttons on a contents page, that will go to sheet 2, and 3 when clicked.
I have tried assigning
Sub Sheet2()
Sheets("Sheet2").Select
End Sub
to a button, but then when i press the button always an error comes up!
does the first line have to be Sub Button1_Click()?
Im not sure how to save it in VBA
What exactly should the code be?
Thanks.
Basically i need to have 2 buttons on a contents page, that will go to sheet 2, and 3 when clicked.
I have tried assigning
Sub Sheet2()
Sheets("Sheet2").Select
End Sub
to a button, but then when i press the button always an error comes up!
does the first line have to be Sub Button1_Click()?
Im not sure how to save it in VBA
What exactly should the code be?
Thanks.