Idiots guide to macros and buttons

[gorang]

Hi all

If this question is answered already, then I apologise,
I have tried to use the searh function in the forum but it dosent find any macthes for me

I have never done anything with macro's before (am not too bad on formulas though) and have been trying to follow the help in excell, but getting now where fast

I am trying to add 2 buttons to each worksheet to go to the other 2 worksheets

ie.
button 1 in worksheet 1 to select worksheet 2
button 2 in worksheet 1 to select worksheet 3
button 1 in worksheet 2 to select worksheet 1
button 2 in worksheet 2 to select worksheet 3

you get the idea

I can get the button onto the workshet and can name it for where i want it to go to, but the button clicks and nothing happens

I have tried to record the macro as well but don't know if i am doing that right as I am not entirely understanding the process that it is doing

is there a idiots guide somewhere that I can have a look at to explain the macros process in english for me instead of double dutch

thanks for your replies in anticipation

Again sorry if this has been answered before

Gordon

[VBA Noob]

Hi,

Do these links help

http://www.mcgimpsey.com/macoffice/w...ignmacros.html

http://www.ozgrid.com/Excel/assign-macros.htm

http://wordtips.vitalnews.com/Pages/...Your_Text.html

http://exceltips.vitalnews.com/Pages...Worksheet.html



VBA Noob

[VBA Noob]

Hi,

You don't need a macro to link to another cell. Try Hyperlinks

http://www.techonthenet.com/excel/hy...ks/create1.php

http://www.homeandlearn.co.uk/ME/mes11p4.html

http://peltiertech.com/Excel/Hyperlinks.html

VBA Noob

[VBA Noob]

Hi again,

Example spreadsheet

VBA Noob

[gorang]

Thanks for the Qick reply VBA Noob

Do these links help

Kind of

I can get the button up and be able to click it but noth happens

when I go to edit macro this is what i get

Sub sheet2()
'
' sheet2 Macro
' Macro recorded 24/12/2006
'

'
End Sub
Sub sheet3()
'
' sheet3 Macro
' Macro recorded 24/12/2006
'

'
End Sub

I am not sure if I am recording it correctly of if I am barking up the wrong tree alltogether

Thanks Gordon

[gorang]

Got it

Thanks for all your help

Thank you

[VBA Noob]

No problem

Thanks fo the feedback

VBA Noob