Hello,

You may have to allow the macro to edit a protected worksheet, using
the "userinterfaceonly" property, for example:

Dim wSheet As Worksheet
For Each wSheet In Worksheets
wSheet.Protect Password:="Secret", UserInterFaceOnly:=True
Next wSheet
End Sub



HTH,
JP

On Oct 19, 5:32 pm, Billy Liddel
wrote:
Jason
I created a range name "Data" to allow user entry. The GoTo Reference
selects the range and spell checks it.

Range("B2").Select ermoves the selection on the whole range and selects the
first cell in the range for the next data entry.

I've been out for this afternoon so another delay!

Regards
Peter