JP,
This was very helpful as I did have one sheet in the workbook that required
me to put in the password for the unprotect. However I'm not familliar with
the "userinterfaceonly" property. If you could explain how that affects the
macro I would be very grateful. I really appreciate your willingness to help
me out!

Jason

"JP" wrote:

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