Public Sub MyButton_Click()
Worksheets("Sheet2").Select
End Sub

--
__________________________________
HTH

Bob

"aussiegirlone" wrote in message
...
What I would like to do is have a command button on click, to go to
another
sheet on a specified cell range in the same workbook. It's just that I do
not
know how to create macros or codes to make any command button work. Any
help
me would be much appreciated.