linking buttons

[Guest]

hey
i've already created a button(form). How do i link this button to another
worksheet in the same workbook?

thank you

 

[Don Guillett]

Hey, what are you talking about?

 

[Guest]

I was thinking of creating a link from one worksheet in excel, to the other.
Can this only be done using hyperlinks?
As I have already created a form button.
I wanted it to link to another worksheet when i click it.
Is it possible?

Thank You

 

[Guest]

There are two articles available in VBA help that you should probably read.
One is "Using ActiveX Controls in Documents" and the other is "Using ActiveX
Controls in Sheets". To access these articles, open VBA help and type "Using
ActiveX Controls" in the search box. Afer you have read the articales, maybe
you can be more specific about what you want to do.

 

[David Hilberg]

If you add a command button to a sheet, then (while still in design
mode) you can double click it to go to the vba editor. In the command
button's Click routine, insert

sheets("name of sheet to jump to").activate

HTH,

David