Customizing a dictionary

[Grant]

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?

 

[Vijay]

You can use "Auto Correct Options" where in you can add in list the words
which you want to convert with other one, and by doing this whenever you will
write those words, system will convert to the new one automatically. The path
in excel 2007 is Excel Options/Proofing/auto correct options.

Vijay

 

[Grant]

That is a good suggestion, however some words have different meanings
depending on how you use them in a sentence. Sometimes I need the word to be
plural, past, or present tense. Is there a way I can create another
dictionary and make a rule stating that this list of words cannot be used. I
want the word to be flagged and then I can change it manually. The list I
have contains 100 + words that I can't use.

 

[Dave Peterson]

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.