Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm creating templates for users to use as reports - these have (among many
others) one merged cell which contains free text and of course the users don't spell check. I'm quite happy coding for spell checking before saving, but would prefer to spellcheck only the relevant cell and I cannot get this to work. Code given below: Set wsActive = Worksheets("Current Status") wsActive.Select If Range("B24").Value < "" Then wsActive.Range("B24").CheckSpelling _ CustomDictionary:="CUSTOM.DIC", _ IgnoreUppercase:=False, _ AlwaysSuggest:=True End If This still checks the entire sheet, so I don't know what to do next. Also, can I spellcheck only the value of this cell (Free entry text) without the comment [which was added as short notes on the type of content required in the cell]. Thanks in advance Anne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
check spelling as you type | New Users to Excel | |||
Check Spelling With Sheet Protected | Excel Discussion (Misc queries) | |||
... Can I set Spell Check to automatically check my spelling ... | Setting up and Configuration of Excel | |||
Spelling check in excel | Excel Programming | |||
Spelling check | Excel Programming |