Ok I have this spell check script working now thanks to "VBA Noob" however The spell checker isn't automatic. Which means I need to keep changing the names in each worksheet manually.
So is there a way that I could use the spellchecker or a script that would look at Sheet1 column (A:A) with a list of names that are correct and check all my other sheets2,3,4,5 ect. Column (A:A) and make changes to the names that dont match sheet1?
Here is an example book:
Again Thanks everyone for all your help.
Mike
Bookmarks