Button /cell formula to automatically change sheets

Hi, i'm new to excel functions and programming and wanted to know how I can add a button on one sheet that switches to another workbook sheet when the user activates it by selecting the button with the mouse.

Thanks in advance for any help/advice.

-mcqueen

here is wht u do:

make sure u r on the sheet which the button will be added
and then go to
Tools-Macro-Recrod new Macro

and den name the macro click ok

and then go to the page you want the button to go to
and then go to
tools-macro-stop recording

then go to the sheet which u want to add da button too

then right click at the top and ensure that the form is checked

and then choose the button

make da button

and then choose the macro u just recorded

hope that helps

Thanks for the help,

From your advice I've figured out how to record the macro.

However I dont understand what I need to do here:

[Then right click at the top and ensure that the form is checked]

can you please explain?

Many thanks for the help

-mcqueen

Solved it now thanks.

mcqueen