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

"excel-chump" wrote:

Peter,
What does the "Range("B2").Select" do in this code?

Sorry for the delay in the response. Our servers have been down almost all
day. (Aaargh!!!)
Thanks for your help, Jason

"Billy Liddel" wrote:

I just recorded this:

Sub Macro2()

ActiveSheet.Unprotect
Application.Goto Reference:="data"
Selection.CheckSpelling SpellLang:=2057
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Range("B2").Select
End Sub

Would this be OK?
Peter

"excel-chump" wrote:

That about sums it up. Right now I have protect sheet active so that people
can only input data in the appropriate fields and not change the format of
the sheet or the title fields. Having it protected disallows spell check.
Any thoughts or ideas? Any comments welcome. :)