Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm not sure if this still works, but MSOffice used to support a user exclusion
dictionary. Even though "manger" is a valid word, it's not used very much in business environments. And mistyping "manager" as "manger" wouldn't be flagged as a typo. This was written for Word 97 (MSOffice 97). You may want to test to see if it applies to the version that you and your client are using: WD97: How to Create an Exclude Dictionary http://support.microsoft.com/kb/181641 This file was common to all the programs in the MSOffice suite. But I'm sure it was used more often in MSWord. You may want to post a question in a forum dedicated to MSWord and specify the versions of office that will be used if you have trouble. ====== But I don't think that's enough (well, for me, it wouldn't be). I think I'd create a new separate workbook that contained a single worksheet. And in column A, I'd put all the words (and variations of those words). Then I'd create a macro that would search through all the worksheets (formulas, values, comments, chart labels, ...) and display the results if each of the words was found. Grant wrote: I have a customer overseas that I write publications for. My customer has provided me with a list of words that they do not want to see in the publications due to language differences. I am wondering if I can customize a dictionary and create a rule that will notify me if that word(s) is used during a routine spell check. Currently, when I run a spell check it tells me if I have a misspelled word. The words that I want to check are not misspellings but considered unacceptable in the foreign culture my firm is representing. Is there a way to achieve this? -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Function Dictionary v3 | Excel Discussion (Misc queries) | |||
How do I delete word from Excel dictionary | Excel Discussion (Misc queries) | |||
is there a complete language dictionary in excell? | Excel Discussion (Misc queries) | |||
"Excel Function Dictionary" new URL? | Excel Worksheet Functions | |||
How to remove a word from dictionary? | Excel Discussion (Misc queries) |