Using a button to select a macro to go to a sheet

[aldino]

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.

 

[iggydarsa]

the name depends on your button's name (in this case "Button1" I suppose)

then it should start with: Sub Button1_Click()

 

[WillR]

What sort of button are you using ?

There are two main types,

A forms button You can right click these & assign a macro from a normal module

A controls button - you need to code this in the relevant sheet code module