Colo,
Thanks for your time and trouble, but I must be dumb as.
All I kept getting was "Compile Errors"
I did however end up working out my problem, although it took som
time.
This is what I ended up with...

Private Sub cmdButton1_Click()
If optButton1.Value = True Then
Application.Goto Reference:=Worksheets("Sheet1").Range("A1"), _
Scroll:=True
End If
If optButton2.Value = True Then
Application.Goto Reference:=Worksheets("Sheet2").Range("A1"), _
Scroll:=True
End If
If optButton3.Value = True Then
Application.Goto Reference:=Worksheets("Sheet3").Range("A1"), _
Scroll:=True
End If
If optButton4.Value = True Then
Application.Goto Reference:=Worksheets("Sheet4").Range("A1"), _
Scroll:=True
End If

End Sub
........................................

Private Sub optButton1_Click()

End Sub
........................................
Private Sub optButton2_Click()

End Sub
........................................

Private Sub optButton3_Click()

End Sub
........................................

Private Sub optButton4_Click()

End Sub
.......................................

CHEERS
GRAHA

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements