Spell Check

H

Hans Emilio

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,
 
H

Hans Emilio

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,
 
D

Dave Peterson

I don't have another guess.

MSWord remembers which word you told it to ignore, but I've never seen that
option in Excel.

I don't have another guess.

(Just curious, though...what are the words that are ignored?)

Hans said:
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,
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spell Checking on a protected sheet 3
Spell Checking on a protected sheet 4
Spell Check Macro - Move to Cell 0
spellchecking only the unlocked cells of a protected spreadsheet? 5
including macro in protected worksheet 2
textbox spell check 5
spellLang # for UK 2
Spell Check Protect Reprotect with same settings 1

Top