Spell check in forms

Dan Johnson · External Since: Jul 15, 2009 Posts: 4

I have created a form with memo fields utilizing Word 2007. When the
document has been protected, the spell check feature is grayed out.
Obviously, the "locked" areas of the form have already been checked and
do not need the feature; however, the memo field being completed by the
user has not. Is there some means of activating spell check for the
filled in portion or is it totally non-functional in a form?

Suzanne S. Barnhill · External Since: Sep 26, 2003 Posts: 24065

If you are using the legacy form fields, see
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Dan Johnson" <d_johnso.DeleteThis@comporium.net> wrote in message
news:uBfBtsVBKHA.4984@TK2MSFTNGP05.phx.gbl...
>I have created a form with memo fields utilizing Word 2007. When the
>document has been protected, the spell check feature is grayed out.
>Obviously, the "locked" areas of the form have already been checked and do
>not need the feature; however, the memo field being completed by the user
>has not. Is there some means of activating spell check for the filled in
>portion or is it totally non-functional in a form?
>

Dan Johnson · External Since: Jul 15, 2009 Posts: 4

Suzanne S. Barnhill wrote:
> If you are using the legacy form fields, see
> http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
>
Suzanne,

Thanks for the help so far.

The first line of the instructions simply say,

"Create a macro, and paste the following code in, first deleting
anything in the code module that Microsoft inserted automatically."

Should this macro be inserted into the enter or exit section of the
properties of each memo field? If so, it is erroring at oDoc.Unprotect
of the statement below as it tries to enter the enter control or exit
the exit control:

If we've got this far, it's protected for forms
'Now unprotect the document
oDoc.Unprotect
oDoc.SpellingChecked = False

Your help is sincerely appreciate.

Dan Johnson

Dan Johnson · External Since: Jul 15, 2009 Posts: 4

Dan Johnson wrote:
> Suzanne S. Barnhill wrote:
>> If you are using the legacy form fields, see
>> http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
>>
> Suzanne,
>
> Thanks for the help so far.
>
> The first line of the instructions simply say,
>
> "Create a macro, and paste the following code in, first deleting
> anything in the code module that Microsoft inserted automatically."
>
>
>
> Should this macro be inserted into the enter or exit section of the
> properties of each memo field? If so, it is erroring at oDoc.Unprotect
> of the statement below as it tries to enter the enter control or exit
> the exit control:
>
> If we've got this far, it's protected for forms
> 'Now unprotect the document
> oDoc.Unprotect
> oDoc.SpellingChecked = False
>
> Your help is sincerely appreciate.
>
> Dan Johnson

That is the instructions to which I am referring. I have the entire
section after for the macro...

Is it possible that the form is then protected that it is erring at that
point. I am trying to figure out the syntax for unprotecting the
document but it does not work with the step in Section 2 of the
instructions found later in that same set of instructions.

Suzanne S. Barnhill · External Since: Sep 26, 2003 Posts: 24065

As the article says, the macro should be saved in the template itself. See
http://www.gmayor.com/installing_macro.htm for a better approach to the
"create a macro" part (though you seem to have got past that). Then put a
button for the macro on the toolbar in the template. If you've read to the
bottom of the article, you'll see that there's a sample available.

If you still have questions after looking at the sample, then you probably
need help from one of the people who wrote the macro/article. I don't know
how many of them are still around, but your best bet is to post in the
microsoft.public.word.vba NG and mention the article you're trying to
follow.

Do also note that adding this macro will require that users either enable
macros or store the template in a trusted location.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Dan Johnson" <d_johnso.DeleteThis@comporium.net> wrote in message
news:%23cxph4XBKHA.1248@TK2MSFTNGP04.phx.gbl...
> Dan Johnson wrote:
>> Suzanne S. Barnhill wrote:
>>> If you are using the legacy form fields, see
>>> http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
>>>
>> Suzanne,
>>
>> Thanks for the help so far.
>>
>> The first line of the instructions simply say,
>>
>> "Create a macro, and paste the following code in, first deleting anything
>> in the code module that Microsoft inserted automatically."
>>
>>
>>
>> Should this macro be inserted into the enter or exit section of the
>> properties of each memo field? If so, it is erroring at oDoc.Unprotect of
>> the statement below as it tries to enter the enter control or exit the
>> exit control:
>>
>> If we've got this far, it's protected for forms
>> 'Now unprotect the document
>> oDoc.Unprotect
>> oDoc.SpellingChecked = False
>>
>> Your help is sincerely appreciate.
>>
>> Dan Johnson
>
>
> That is the instructions to which I am referring. I have the entire
> section after for the macro...
>
> Is it possible that the form is then protected that it is erring at that
> point. I am trying to figure out the syntax for unprotecting the document
> but it does not work with the step in Section 2 of the instructions found
> later in that same set of instructions.
>

Dan Johnson · External Since: Jul 15, 2009 Posts: 4

Suzanne S. Barnhill wrote:
> As the article says, the macro should be saved in the template itself.
> See http://www.gmayor.com/installing_macro.htm for a better approach to
> the "create a macro" part (though you seem to have got past that). Then
> put a button for the macro on the toolbar in the template. If you've
> read to the bottom of the article, you'll see that there's a sample
> available.
>
> If you still have questions after looking at the sample, then you
> probably need help from one of the people who wrote the macro/article. I
> don't know how many of them are still around, but your best bet is to
> post in the microsoft.public.word.vba NG and mention the article you're
> trying to follow.
>
> Do also note that adding this macro will require that users either
> enable macros or store the template in a trusted location.
>
Suzanne,

I finally did as I initially should have and copied the entire text of
the macro from the website you sent. After doing that, it worked
perfectly. My follow-up questions should have been directed back at
myself to see if I had the ability to follow instructions which,
obviously, I didn't. Thanks so very much for the help.

Dan

Suzanne S. Barnhill · External Since: Sep 26, 2003 Posts: 24065

I'm glad you got it working--especially since (a) I would have been
unavailable to help you further because I left on July 16 for three weeks
abroad, and (b) I would have been unable to help you further in any case
because I am totally ignorant about VBA!

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Dan Johnson" <d_johnso.DeleteThis@comporium.net> wrote in message
news:%23nLPmQkBKHA.1248@TK2MSFTNGP04.phx.gbl...
> Suzanne S. Barnhill wrote:
>> As the article says, the macro should be saved in the template itself.
>> See http://www.gmayor.com/installing_macro.htm for a better approach to
>> the "create a macro" part (though you seem to have got past that). Then
>> put a button for the macro on the toolbar in the template. If you've read
>> to the bottom of the article, you'll see that there's a sample available.
>>
>> If you still have questions after looking at the sample, then you
>> probably need help from one of the people who wrote the macro/article. I
>> don't know how many of them are still around, but your best bet is to
>> post in the microsoft.public.word.vba NG and mention the article you're
>> trying to follow.
>>
>> Do also note that adding this macro will require that users either enable
>> macros or store the template in a trusted location.
>>
> Suzanne,
>
> I finally did as I initially should have and copied the entire text of the
> macro from the website you sent. After doing that, it worked perfectly. My
> follow-up questions should have been directed back at myself to see if I
> had the ability to follow instructions which, obviously, I didn't. Thanks
> so very much for the help.
>
> Dan
>