Thread: Spell Check
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Hans Emilio Hans Emilio is offline
external usenet poster
 
Posts: 2
Default Spell Check

No, there were several words that were mispelled and were not picked-up by
the dictionary. I cleared the "add to dictionary" list from Microsoft Word,
so I don't know what is causing this mishap.

Thanks,
--
Hans Emilio


"Dave Peterson" wrote:

Just a guess...

Did the misspelled word get added to the dictionary?

Hans Emilio wrote:

Hello,

I am stomped, I have the following code:

Private Sub CommandButton1_Click()
ActiveSheet.Unprotect Password:="xx"
Range("A:A").Select
Cells.CheckSpelling CustomDictionary:="CUSTOM.DIC", IgnoreUppercase:=False _
, AlwaysSuggest:=True

ActiveSheet.Protect Password:="xx"
End Sub

However, the spell check after so many time using it, it does not correct
the spelling. Can someone explain to me as to why this happens, or a
solution for this problem?

Appreciate any input and help from anyone.

Thank-you,

--
Hans Emilio


--

Dave Peterson