I have a form with text fields in it. The form is protected. I also have 
bookmarks with matching referance fields. The bookmarks are set to calculate 
upon exit. The problem is as soon as the user tabs through one of the fields 
it sets the Language setting back to do not spell check for the whole 
document. I have tried the macro on the MVP website and it does not work 
because the text fields get set back to not spell check and it does not 
change that. I can get it to spell check if I unprotect the form, highlight 
the text, go to the language setting and uncheck the do not spell check. But 
that has to be done on every text field I want to spell check on every time I 
use the form. Can a macro be written or modified to do this for me? Or is 
there a way to set the document to allow spell check even if it has bookmarks 
that calculate on exit. I know its the bookmarks that are the problem because 
the document keeps the language setting I give it and spell checks the text 
fileds until I add the bookmark and tell it to calculate on exit. I'm at the 
end of my rope on this so any help would be great. I have already tried the 
Cnt A and it doed not work either. I've also tried setting the default 
language with the do not check spelling and auto detect the lanaguage boxes 
unchecked. As soon as the activity hour glass displays after you exit a 
bookmark field it sets the do not check grammer or spelling. The check bos is 
filled in by a green box instead of a check. Not sure what that means. I am 
running Office 2003.

Hi,

1) Bookmarks are not set to calculate on exit. They are just there or not 
there. Form fields, which have bookmarks set by default, can be set to 
calculate on exit.

2) A protected form must be protected for the fields to work properly. If 
you can use Ctrl-A and select something outside of a single field, it is not 
protected.

3) If you are looking for squiggly red lines to appear as you type in a 
protected form you are out of luck. It won't happen.

4) The macro to check spelling works, but it assumes that you are working 
with form fields in a document that is protected for forms. You have to call 
it when you want to check the spelling.

What you are talking about is what Word calls an "online form." Check this 
in help. For more about online forms, follow the links at 
http://addbalance.com/word/wordwebresources.htm#Forms or 
http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian 
Chapman's series of articles.

Hope this helps,
-- 

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of 
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"jrfloyd"  wrote in message 
news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
>I have a form with text fields in it. The form is protected. I also have
> bookmarks with matching referance fields. The bookmarks are set to 
> calculate
> upon exit. The problem is as soon as the user tabs through one of the 
> fields
> it sets the Language setting back to do not spell check for the whole
> document. I have tried the macro on the MVP website and it does not work
> because the text fields get set back to not spell check and it does not
> change that. I can get it to spell check if I unprotect the form, 
> highlight
> the text, go to the language setting and uncheck the do not spell check. 
> But
> that has to be done on every text field I want to spell check on every 
> time I
> use the form. Can a macro be written or modified to do this for me? Or is
> there a way to set the document to allow spell check even if it has 
> bookmarks
> that calculate on exit. I know its the bookmarks that are the problem 
> because
> the document keeps the language setting I give it and spell checks the 
> text
> fileds until I add the bookmark and tell it to calculate on exit. I'm at 
> the
> end of my rope on this so any help would be great. I have already tried 
> the
> Cnt A and it doed not work either. I've also tried setting the default
> language with the do not check spelling and auto detect the lanaguage 
> boxes
> unchecked. As soon as the activity hour glass displays after you exit a
> bookmark field it sets the do not check grammer or spelling. The check bos 
> is
> filled in by a green box instead of a check. Not sure what that means. I 
> am
> running Office 2003.
>

Thanks. I will check those sites. I have seen some of the macros where it says
Active document. Range. Language ID = wdEnglishUS. If it had a line that 
would uncheck the do not check spelling and grammer box I think it would fix 
my problem. I'm by no means a Word or Macro expert so I don't know how to add 
that command or if it would even work. What do you think?

"Charles Kenyon" wrote:

> Hi,
> 
> 1) Bookmarks are not set to calculate on exit. They are just there or not 
> there. Form fields, which have bookmarks set by default, can be set to 
> calculate on exit.
> 
> 2) A protected form must be protected for the fields to work properly. If 
> you can use Ctrl-A and select something outside of a single field, it is not 
> protected.
> 
> 3) If you are looking for squiggly red lines to appear as you type in a 
> protected form you are out of luck. It won't happen.
> 
> 4) The macro to check spelling works, but it assumes that you are working 
> with form fields in a document that is protected for forms. You have to call 
> it when you want to check the spelling.
> 
> What you are talking about is what Word calls an "online form." Check this 
> in help. For more about online forms, follow the links at 
> http://addbalance.com/word/wordwebresources.htm#Forms or 
> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian 
> Chapman's series of articles.
> 
> Hope this helps,
> -- 
> 
> Charles Kenyon
> 
> Word New User FAQ & Web Directory: http://addbalance.com/word
> 
> Intermediate User's Guide to Microsoft Word (supplemented version of 
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> 
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>  --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
> 
> "jrfloyd"  wrote in message 
> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
> >I have a form with text fields in it. The form is protected. I also have
> > bookmarks with matching referance fields. The bookmarks are set to 
> > calculate
> > upon exit. The problem is as soon as the user tabs through one of the 
> > fields
> > it sets the Language setting back to do not spell check for the whole
> > document. I have tried the macro on the MVP website and it does not work
> > because the text fields get set back to not spell check and it does not
> > change that. I can get it to spell check if I unprotect the form, 
> > highlight
> > the text, go to the language setting and uncheck the do not spell check. 
> > But
> > that has to be done on every text field I want to spell check on every 
> > time I
> > use the form. Can a macro be written or modified to do this for me? Or is
> > there a way to set the document to allow spell check even if it has 
> > bookmarks
> > that calculate on exit. I know its the bookmarks that are the problem 
> > because
> > the document keeps the language setting I give it and spell checks the 
> > text
> > fileds until I add the bookmark and tell it to calculate on exit. I'm at 
> > the
> > end of my rope on this so any help would be great. I have already tried 
> > the
> > Cnt A and it doed not work either. I've also tried setting the default
> > language with the do not check spelling and auto detect the lanaguage 
> > boxes
> > unchecked. As soon as the activity hour glass displays after you exit a
> > bookmark field it sets the do not check grammer or spelling. The check bos 
> > is
> > filled in by a green box instead of a check. Not sure what that means. I 
> > am
> > running Office 2003.
> > 
> 
> 
>

I just ran one of the macros and it is skipping the text fields becasue they 
are still set to not check spelling and grammer. if I highlight the text and 
uncheck the box it works fine. 

"jrfloyd" wrote:

> Thanks. I will check those sites. I have seen some of the macros where it says
> Active document. Range. Language ID = wdEnglishUS. If it had a line that 
> would uncheck the do not check spelling and grammer box I think it would fix 
> my problem. I'm by no means a Word or Macro expert so I don't know how to add 
> that command or if it would even work. What do you think?
> 
> "Charles Kenyon" wrote:
> 
> > Hi,
> > 
> > 1) Bookmarks are not set to calculate on exit. They are just there or not 
> > there. Form fields, which have bookmarks set by default, can be set to 
> > calculate on exit.
> > 
> > 2) A protected form must be protected for the fields to work properly. If 
> > you can use Ctrl-A and select something outside of a single field, it is not 
> > protected.
> > 
> > 3) If you are looking for squiggly red lines to appear as you type in a 
> > protected form you are out of luck. It won't happen.
> > 
> > 4) The macro to check spelling works, but it assumes that you are working 
> > with form fields in a document that is protected for forms. You have to call 
> > it when you want to check the spelling.
> > 
> > What you are talking about is what Word calls an "online form." Check this 
> > in help. For more about online forms, follow the links at 
> > http://addbalance.com/word/wordwebresources.htm#Forms or 
> > http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially Dian 
> > Chapman's series of articles.
> > 
> > Hope this helps,
> > -- 
> > 
> > Charles Kenyon
> > 
> > Word New User FAQ & Web Directory: http://addbalance.com/word
> > 
> > Intermediate User's Guide to Microsoft Word (supplemented version of 
> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> > 
> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >  --------- --------- --------- --------- --------- ---------
> > This message is posted to a newsgroup. Please post replies
> > and questions to the newsgroup so that others can learn
> > from my ignorance and your wisdom.
> > 
> > "jrfloyd"  wrote in message 
> > news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
> > >I have a form with text fields in it. The form is protected. I also have
> > > bookmarks with matching referance fields. The bookmarks are set to 
> > > calculate
> > > upon exit. The problem is as soon as the user tabs through one of the 
> > > fields
> > > it sets the Language setting back to do not spell check for the whole
> > > document. I have tried the macro on the MVP website and it does not work
> > > because the text fields get set back to not spell check and it does not
> > > change that. I can get it to spell check if I unprotect the form, 
> > > highlight
> > > the text, go to the language setting and uncheck the do not spell check. 
> > > But
> > > that has to be done on every text field I want to spell check on every 
> > > time I
> > > use the form. Can a macro be written or modified to do this for me? Or is
> > > there a way to set the document to allow spell check even if it has 
> > > bookmarks
> > > that calculate on exit. I know its the bookmarks that are the problem 
> > > because
> > > the document keeps the language setting I give it and spell checks the 
> > > text
> > > fileds until I add the bookmark and tell it to calculate on exit. I'm at 
> > > the
> > > end of my rope on this so any help would be great. I have already tried 
> > > the
> > > Cnt A and it doed not work either. I've also tried setting the default
> > > language with the do not check spelling and auto detect the lanaguage 
> > > boxes
> > > unchecked. As soon as the activity hour glass displays after you exit a
> > > bookmark field it sets the do not check grammer or spelling. The check bos 
> > > is
> > > filled in by a green box instead of a check. Not sure what that means. I 
> > > am
> > > running Office 2003.
> > > 
> > 
> > 
> >

We are talking about the macro from 
http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm inserted 
without modification, right?

-- 
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.
"jrfloyd"  wrote in message 
news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
> Thanks. I will check those sites. I have seen some of the macros where it 
> says
> Active document. Range. Language ID = wdEnglishUS. If it had a line that
> would uncheck the do not check spelling and grammer box I think it would 
> fix
> my problem. I'm by no means a Word or Macro expert so I don't know how to 
> add
> that command or if it would even work. What do you think?
>
> "Charles Kenyon" wrote:
>
>> Hi,
>>
>> 1) Bookmarks are not set to calculate on exit. They are just there or not
>> there. Form fields, which have bookmarks set by default, can be set to
>> calculate on exit.
>>
>> 2) A protected form must be protected for the fields to work properly. If
>> you can use Ctrl-A and select something outside of a single field, it is 
>> not
>> protected.
>>
>> 3) If you are looking for squiggly red lines to appear as you type in a
>> protected form you are out of luck. It won't happen.
>>
>> 4) The macro to check spelling works, but it assumes that you are working
>> with form fields in a document that is protected for forms. You have to 
>> call
>> it when you want to check the spelling.
>>
>> What you are talking about is what Word calls an "online form." Check 
>> this
>> in help. For more about online forms, follow the links at
>> http://addbalance.com/word/wordwebresources.htm#Forms or
>> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially 
>> Dian
>> Chapman's series of articles.
>>
>> Hope this helps,
>> -- 
>>
>> Charles Kenyon
>>
>> Word New User FAQ & Web Directory: http://addbalance.com/word
>>
>> Intermediate User's Guide to Microsoft Word (supplemented version of
>> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>>
>> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>>  --------- --------- --------- --------- --------- ---------
>> This message is posted to a newsgroup. Please post replies
>> and questions to the newsgroup so that others can learn
>> from my ignorance and your wisdom.
>>
>> "jrfloyd"  wrote in message
>> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
>> >I have a form with text fields in it. The form is protected. I also have
>> > bookmarks with matching referance fields. The bookmarks are set to
>> > calculate
>> > upon exit. The problem is as soon as the user tabs through one of the
>> > fields
>> > it sets the Language setting back to do not spell check for the whole
>> > document. I have tried the macro on the MVP website and it does not 
>> > work
>> > because the text fields get set back to not spell check and it does not
>> > change that. I can get it to spell check if I unprotect the form,
>> > highlight
>> > the text, go to the language setting and uncheck the do not spell 
>> > check.
>> > But
>> > that has to be done on every text field I want to spell check on every
>> > time I
>> > use the form. Can a macro be written or modified to do this for me? Or 
>> > is
>> > there a way to set the document to allow spell check even if it has
>> > bookmarks
>> > that calculate on exit. I know its the bookmarks that are the problem
>> > because
>> > the document keeps the language setting I give it and spell checks the
>> > text
>> > fileds until I add the bookmark and tell it to calculate on exit. I'm 
>> > at
>> > the
>> > end of my rope on this so any help would be great. I have already tried
>> > the
>> > Cnt A and it doed not work either. I've also tried setting the default
>> > language with the do not check spelling and auto detect the lanaguage
>> > boxes
>> > unchecked. As soon as the activity hour glass displays after you exit a
>> > bookmark field it sets the do not check grammer or spelling. The check 
>> > bos
>> > is
>> > filled in by a green box instead of a check. Not sure what that means. 
>> > I
>> > am
>> > running Office 2003.
>> >
>>
>>
>>

Yes. Thats the one I have. Also. If I get this one working. how do you run 
the macro if the form is protected? Should I add it to a run macro on exit 
field at the end. I wanted to add a toolbar icon but I can not run the macro 
from the toolbar if the form is prtoected. 

"Charles Kenyon" wrote:

> We are talking about the macro from 
> http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm inserted 
> without modification, right?
> 
> -- 
> Charles Kenyon
> 
> Word New User FAQ & Web Directory: http://addbalance.com/word
> 
> Intermediate User's Guide to Microsoft Word (supplemented version of
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> 
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>  --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
> "jrfloyd"  wrote in message 
> news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
> > Thanks. I will check those sites. I have seen some of the macros where it 
> > says
> > Active document. Range. Language ID = wdEnglishUS. If it had a line that
> > would uncheck the do not check spelling and grammer box I think it would 
> > fix
> > my problem. I'm by no means a Word or Macro expert so I don't know how to 
> > add
> > that command or if it would even work. What do you think?
> >
> > "Charles Kenyon" wrote:
> >
> >> Hi,
> >>
> >> 1) Bookmarks are not set to calculate on exit. They are just there or not
> >> there. Form fields, which have bookmarks set by default, can be set to
> >> calculate on exit.
> >>
> >> 2) A protected form must be protected for the fields to work properly. If
> >> you can use Ctrl-A and select something outside of a single field, it is 
> >> not
> >> protected.
> >>
> >> 3) If you are looking for squiggly red lines to appear as you type in a
> >> protected form you are out of luck. It won't happen.
> >>
> >> 4) The macro to check spelling works, but it assumes that you are working
> >> with form fields in a document that is protected for forms. You have to 
> >> call
> >> it when you want to check the spelling.
> >>
> >> What you are talking about is what Word calls an "online form." Check 
> >> this
> >> in help. For more about online forms, follow the links at
> >> http://addbalance.com/word/wordwebresources.htm#Forms or
> >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially 
> >> Dian
> >> Chapman's series of articles.
> >>
> >> Hope this helps,
> >> -- 
> >>
> >> Charles Kenyon
> >>
> >> Word New User FAQ & Web Directory: http://addbalance.com/word
> >>
> >> Intermediate User's Guide to Microsoft Word (supplemented version of
> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >>
> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >>  --------- --------- --------- --------- --------- ---------
> >> This message is posted to a newsgroup. Please post replies
> >> and questions to the newsgroup so that others can learn
> >> from my ignorance and your wisdom.
> >>
> >> "jrfloyd"  wrote in message
> >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
> >> >I have a form with text fields in it. The form is protected. I also have
> >> > bookmarks with matching referance fields. The bookmarks are set to
> >> > calculate
> >> > upon exit. The problem is as soon as the user tabs through one of the
> >> > fields
> >> > it sets the Language setting back to do not spell check for the whole
> >> > document. I have tried the macro on the MVP website and it does not 
> >> > work
> >> > because the text fields get set back to not spell check and it does not
> >> > change that. I can get it to spell check if I unprotect the form,
> >> > highlight
> >> > the text, go to the language setting and uncheck the do not spell 
> >> > check.
> >> > But
> >> > that has to be done on every text field I want to spell check on every
> >> > time I
> >> > use the form. Can a macro be written or modified to do this for me? Or 
> >> > is
> >> > there a way to set the document to allow spell check even if it has
> >> > bookmarks
> >> > that calculate on exit. I know its the bookmarks that are the problem
> >> > because
> >> > the document keeps the language setting I give it and spell checks the
> >> > text
> >> > fileds until I add the bookmark and tell it to calculate on exit. I'm 
> >> > at
> >> > the
> >> > end of my rope on this so any help would be great. I have already tried
> >> > the
> >> > Cnt A and it doed not work either. I've also tried setting the default
> >> > language with the do not check spelling and auto detect the lanaguage
> >> > boxes
> >> > unchecked. As soon as the activity hour glass displays after you exit a
> >> > bookmark field it sets the do not check grammer or spelling. The check 
> >> > bos
> >> > is
> >> > filled in by a green box instead of a check. Not sure what that means. 
> >> > I
> >> > am
> >> > running Office 2003.
> >> >
> >>
> >>
> >> 
> 
> 
>

You certainly can run a macro from a toolbar in a protected form. See note 3 
on the page I gave you as a reference. You want the macro, the custom 
toolbar, and any customizations you make to the Tools toolbar to be stored 
in your template, not in normal.dot.
-- 
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of 
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"jrfloyd"  wrote in message 
news:861A513E-A6C7-4A38-935E-1EF87E62C5F2@microsoft.com...
> Yes. Thats the one I have. Also. If I get this one working. how do you run
> the macro if the form is protected? Should I add it to a run macro on exit
> field at the end. I wanted to add a toolbar icon but I can not run the 
> macro
> from the toolbar if the form is prtoected.
>
> "Charles Kenyon" wrote:
>
>> We are talking about the macro from
>> http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm inserted
>> without modification, right?
>>
>> -- 
>> Charles Kenyon
>>
>> Word New User FAQ & Web Directory: http://addbalance.com/word
>>
>> Intermediate User's Guide to Microsoft Word (supplemented version of
>> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>>
>> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>>  --------- --------- --------- --------- --------- ---------
>> This message is posted to a newsgroup. Please post replies
>> and questions to the newsgroup so that others can learn
>> from my ignorance and your wisdom.
>> "jrfloyd"  wrote in message
>> news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
>> > Thanks. I will check those sites. I have seen some of the macros where 
>> > it
>> > says
>> > Active document. Range. Language ID = wdEnglishUS. If it had a line 
>> > that
>> > would uncheck the do not check spelling and grammer box I think it 
>> > would
>> > fix
>> > my problem. I'm by no means a Word or Macro expert so I don't know how 
>> > to
>> > add
>> > that command or if it would even work. What do you think?
>> >
>> > "Charles Kenyon" wrote:
>> >
>> >> Hi,
>> >>
>> >> 1) Bookmarks are not set to calculate on exit. They are just there or 
>> >> not
>> >> there. Form fields, which have bookmarks set by default, can be set to
>> >> calculate on exit.
>> >>
>> >> 2) A protected form must be protected for the fields to work properly. 
>> >> If
>> >> you can use Ctrl-A and select something outside of a single field, it 
>> >> is
>> >> not
>> >> protected.
>> >>
>> >> 3) If you are looking for squiggly red lines to appear as you type in 
>> >> a
>> >> protected form you are out of luck. It won't happen.
>> >>
>> >> 4) The macro to check spelling works, but it assumes that you are 
>> >> working
>> >> with form fields in a document that is protected for forms. You have 
>> >> to
>> >> call
>> >> it when you want to check the spelling.
>> >>
>> >> What you are talking about is what Word calls an "online form." Check
>> >> this
>> >> in help. For more about online forms, follow the links at
>> >> http://addbalance.com/word/wordwebresources.htm#Forms or
>> >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially
>> >> Dian
>> >> Chapman's series of articles.
>> >>
>> >> Hope this helps,
>> >> -- 
>> >>
>> >> Charles Kenyon
>> >>
>> >> Word New User FAQ & Web Directory: http://addbalance.com/word
>> >>
>> >> Intermediate User's Guide to Microsoft Word (supplemented version of
>> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >>
>> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> >>  --------- --------- --------- --------- --------- ---------
>> >> This message is posted to a newsgroup. Please post replies
>> >> and questions to the newsgroup so that others can learn
>> >> from my ignorance and your wisdom.
>> >>
>> >> "jrfloyd"  wrote in message
>> >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
>> >> >I have a form with text fields in it. The form is protected. I also 
>> >> >have
>> >> > bookmarks with matching referance fields. The bookmarks are set to
>> >> > calculate
>> >> > upon exit. The problem is as soon as the user tabs through one of 
>> >> > the
>> >> > fields
>> >> > it sets the Language setting back to do not spell check for the 
>> >> > whole
>> >> > document. I have tried the macro on the MVP website and it does not
>> >> > work
>> >> > because the text fields get set back to not spell check and it does 
>> >> > not
>> >> > change that. I can get it to spell check if I unprotect the form,
>> >> > highlight
>> >> > the text, go to the language setting and uncheck the do not spell
>> >> > check.
>> >> > But
>> >> > that has to be done on every text field I want to spell check on 
>> >> > every
>> >> > time I
>> >> > use the form. Can a macro be written or modified to do this for me? 
>> >> > Or
>> >> > is
>> >> > there a way to set the document to allow spell check even if it has
>> >> > bookmarks
>> >> > that calculate on exit. I know its the bookmarks that are the 
>> >> > problem
>> >> > because
>> >> > the document keeps the language setting I give it and spell checks 
>> >> > the
>> >> > text
>> >> > fileds until I add the bookmark and tell it to calculate on exit. 
>> >> > I'm
>> >> > at
>> >> > the
>> >> > end of my rope on this so any help would be great. I have already 
>> >> > tried
>> >> > the
>> >> > Cnt A and it doed not work either. I've also tried setting the 
>> >> > default
>> >> > language with the do not check spelling and auto detect the 
>> >> > lanaguage
>> >> > boxes
>> >> > unchecked. As soon as the activity hour glass displays after you 
>> >> > exit a
>> >> > bookmark field it sets the do not check grammer or spelling. The 
>> >> > check
>> >> > bos
>> >> > is
>> >> > filled in by a green box instead of a check. Not sure what that 
>> >> > means.
>> >> > I
>> >> > am
>> >> > running Office 2003.
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Ok. The spell check is working if I leave the document protected and I run it 
from Visual Basic. Any ideas on how to run this without having to open Visual 
Basis but leaving the document protected ? 

"jrfloyd" wrote:

> Yes. Thats the one I have. Also. If I get this one working. how do you run 
> the macro if the form is protected? Should I add it to a run macro on exit 
> field at the end. I wanted to add a toolbar icon but I can not run the macro 
> from the toolbar if the form is prtoected. 
> 
> "Charles Kenyon" wrote:
> 
> > We are talking about the macro from 
> > http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm inserted 
> > without modification, right?
> > 
> > -- 
> > Charles Kenyon
> > 
> > Word New User FAQ & Web Directory: http://addbalance.com/word
> > 
> > Intermediate User's Guide to Microsoft Word (supplemented version of
> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> > 
> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >  --------- --------- --------- --------- --------- ---------
> > This message is posted to a newsgroup. Please post replies
> > and questions to the newsgroup so that others can learn
> > from my ignorance and your wisdom.
> > "jrfloyd"  wrote in message 
> > news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
> > > Thanks. I will check those sites. I have seen some of the macros where it 
> > > says
> > > Active document. Range. Language ID = wdEnglishUS. If it had a line that
> > > would uncheck the do not check spelling and grammer box I think it would 
> > > fix
> > > my problem. I'm by no means a Word or Macro expert so I don't know how to 
> > > add
> > > that command or if it would even work. What do you think?
> > >
> > > "Charles Kenyon" wrote:
> > >
> > >> Hi,
> > >>
> > >> 1) Bookmarks are not set to calculate on exit. They are just there or not
> > >> there. Form fields, which have bookmarks set by default, can be set to
> > >> calculate on exit.
> > >>
> > >> 2) A protected form must be protected for the fields to work properly. If
> > >> you can use Ctrl-A and select something outside of a single field, it is 
> > >> not
> > >> protected.
> > >>
> > >> 3) If you are looking for squiggly red lines to appear as you type in a
> > >> protected form you are out of luck. It won't happen.
> > >>
> > >> 4) The macro to check spelling works, but it assumes that you are working
> > >> with form fields in a document that is protected for forms. You have to 
> > >> call
> > >> it when you want to check the spelling.
> > >>
> > >> What you are talking about is what Word calls an "online form." Check 
> > >> this
> > >> in help. For more about online forms, follow the links at
> > >> http://addbalance.com/word/wordwebresources.htm#Forms or
> > >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm especially 
> > >> Dian
> > >> Chapman's series of articles.
> > >>
> > >> Hope this helps,
> > >> -- 
> > >>
> > >> Charles Kenyon
> > >>
> > >> Word New User FAQ & Web Directory: http://addbalance.com/word
> > >>
> > >> Intermediate User's Guide to Microsoft Word (supplemented version of
> > >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> > >>
> > >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> > >>  --------- --------- --------- --------- --------- ---------
> > >> This message is posted to a newsgroup. Please post replies
> > >> and questions to the newsgroup so that others can learn
> > >> from my ignorance and your wisdom.
> > >>
> > >> "jrfloyd"  wrote in message
> > >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
> > >> >I have a form with text fields in it. The form is protected. I also have
> > >> > bookmarks with matching referance fields. The bookmarks are set to
> > >> > calculate
> > >> > upon exit. The problem is as soon as the user tabs through one of the
> > >> > fields
> > >> > it sets the Language setting back to do not spell check for the whole
> > >> > document. I have tried the macro on the MVP website and it does not 
> > >> > work
> > >> > because the text fields get set back to not spell check and it does not
> > >> > change that. I can get it to spell check if I unprotect the form,
> > >> > highlight
> > >> > the text, go to the language setting and uncheck the do not spell 
> > >> > check.
> > >> > But
> > >> > that has to be done on every text field I want to spell check on every
> > >> > time I
> > >> > use the form. Can a macro be written or modified to do this for me? Or 
> > >> > is
> > >> > there a way to set the document to allow spell check even if it has
> > >> > bookmarks
> > >> > that calculate on exit. I know its the bookmarks that are the problem
> > >> > because
> > >> > the document keeps the language setting I give it and spell checks the
> > >> > text
> > >> > fileds until I add the bookmark and tell it to calculate on exit. I'm 
> > >> > at
> > >> > the
> > >> > end of my rope on this so any help would be great. I have already tried
> > >> > the
> > >> > Cnt A and it doed not work either. I've also tried setting the default
> > >> > language with the do not check spelling and auto detect the lanaguage
> > >> > boxes
> > >> > unchecked. As soon as the activity hour glass displays after you exit a
> > >> > bookmark field it sets the do not check grammer or spelling. The check 
> > >> > bos
> > >> > is
> > >> > filled in by a green box instead of a check. Not sure what that means. 
> > >> > I
> > >> > am
> > >> > running Office 2003.
> > >> >
> > >>
> > >>
> > >> 
> > 
> > 
> >

Read the article, the whole article. You can easily run it from the user 
interface with the document protected. You can set it up so that it is 
invisible to the user that something special is going on by attaching the F7 
key, toolbar buttons, and menu commands to it. See my previous post from 
this afternoon.
-- 
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of 
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"jrfloyd"  wrote in message 
news:E73CD695-E5C3-4F4A-ADDF-A20BA5929DDA@microsoft.com...
> Ok. The spell check is working if I leave the document protected and I run 
> it
> from Visual Basic. Any ideas on how to run this without having to open 
> Visual
> Basis but leaving the document protected ?
>
> "jrfloyd" wrote:
>
>> Yes. Thats the one I have. Also. If I get this one working. how do you 
>> run
>> the macro if the form is protected? Should I add it to a run macro on 
>> exit
>> field at the end. I wanted to add a toolbar icon but I can not run the 
>> macro
>> from the toolbar if the form is prtoected.
>>
>> "Charles Kenyon" wrote:
>>
>> > We are talking about the macro from
>> > http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm 
>> > inserted
>> > without modification, right?
>> >
>> > -- 
>> > Charles Kenyon
>> >
>> > Word New User FAQ & Web Directory: http://addbalance.com/word
>> >
>> > Intermediate User's Guide to Microsoft Word (supplemented version of
>> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >
>> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> >  --------- --------- --------- --------- --------- ---------
>> > This message is posted to a newsgroup. Please post replies
>> > and questions to the newsgroup so that others can learn
>> > from my ignorance and your wisdom.
>> > "jrfloyd"  wrote in message
>> > news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
>> > > Thanks. I will check those sites. I have seen some of the macros 
>> > > where it
>> > > says
>> > > Active document. Range. Language ID = wdEnglishUS. If it had a line 
>> > > that
>> > > would uncheck the do not check spelling and grammer box I think it 
>> > > would
>> > > fix
>> > > my problem. I'm by no means a Word or Macro expert so I don't know 
>> > > how to
>> > > add
>> > > that command or if it would even work. What do you think?
>> > >
>> > > "Charles Kenyon" wrote:
>> > >
>> > >> Hi,
>> > >>
>> > >> 1) Bookmarks are not set to calculate on exit. They are just there 
>> > >> or not
>> > >> there. Form fields, which have bookmarks set by default, can be set 
>> > >> to
>> > >> calculate on exit.
>> > >>
>> > >> 2) A protected form must be protected for the fields to work 
>> > >> properly. If
>> > >> you can use Ctrl-A and select something outside of a single field, 
>> > >> it is
>> > >> not
>> > >> protected.
>> > >>
>> > >> 3) If you are looking for squiggly red lines to appear as you type 
>> > >> in a
>> > >> protected form you are out of luck. It won't happen.
>> > >>
>> > >> 4) The macro to check spelling works, but it assumes that you are 
>> > >> working
>> > >> with form fields in a document that is protected for forms. You have 
>> > >> to
>> > >> call
>> > >> it when you want to check the spelling.
>> > >>
>> > >> What you are talking about is what Word calls an "online form." 
>> > >> Check
>> > >> this
>> > >> in help. For more about online forms, follow the links at
>> > >> http://addbalance.com/word/wordwebresources.htm#Forms or
>> > >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm 
>> > >> especially
>> > >> Dian
>> > >> Chapman's series of articles.
>> > >>
>> > >> Hope this helps,
>> > >> -- 
>> > >>
>> > >> Charles Kenyon
>> > >>
>> > >> Word New User FAQ & Web Directory: http://addbalance.com/word
>> > >>
>> > >> Intermediate User's Guide to Microsoft Word (supplemented version of
>> > >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> > >>
>> > >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> > >>  --------- --------- --------- --------- --------- ---------
>> > >> This message is posted to a newsgroup. Please post replies
>> > >> and questions to the newsgroup so that others can learn
>> > >> from my ignorance and your wisdom.
>> > >>
>> > >> "jrfloyd"  wrote in message
>> > >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
>> > >> >I have a form with text fields in it. The form is protected. I also 
>> > >> >have
>> > >> > bookmarks with matching referance fields. The bookmarks are set to
>> > >> > calculate
>> > >> > upon exit. The problem is as soon as the user tabs through one of 
>> > >> > the
>> > >> > fields
>> > >> > it sets the Language setting back to do not spell check for the 
>> > >> > whole
>> > >> > document. I have tried the macro on the MVP website and it does 
>> > >> > not
>> > >> > work
>> > >> > because the text fields get set back to not spell check and it 
>> > >> > does not
>> > >> > change that. I can get it to spell check if I unprotect the form,
>> > >> > highlight
>> > >> > the text, go to the language setting and uncheck the do not spell
>> > >> > check.
>> > >> > But
>> > >> > that has to be done on every text field I want to spell check on 
>> > >> > every
>> > >> > time I
>> > >> > use the form. Can a macro be written or modified to do this for 
>> > >> > me? Or
>> > >> > is
>> > >> > there a way to set the document to allow spell check even if it 
>> > >> > has
>> > >> > bookmarks
>> > >> > that calculate on exit. I know its the bookmarks that are the 
>> > >> > problem
>> > >> > because
>> > >> > the document keeps the language setting I give it and spell checks 
>> > >> > the
>> > >> > text
>> > >> > fileds until I add the bookmark and tell it to calculate on exit. 
>> > >> > I'm
>> > >> > at
>> > >> > the
>> > >> > end of my rope on this so any help would be great. I have already 
>> > >> > tried
>> > >> > the
>> > >> > Cnt A and it doed not work either. I've also tried setting the 
>> > >> > default
>> > >> > language with the do not check spelling and auto detect the 
>> > >> > lanaguage
>> > >> > boxes
>> > >> > unchecked. As soon as the activity hour glass displays after you 
>> > >> > exit a
>> > >> > bookmark field it sets the do not check grammer or spelling. The 
>> > >> > check
>> > >> > bos
>> > >> > is
>> > >> > filled in by a green box instead of a check. Not sure what that 
>> > >> > means.
>> > >> > I
>> > >> > am
>> > >> > running Office 2003.
>> > >> >
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >

Ok. Thanks again for your help

"Charles Kenyon" wrote:

> Read the article, the whole article. You can easily run it from the user 
> interface with the document protected. You can set it up so that it is 
> invisible to the user that something special is going on by attaching the F7 
> key, toolbar buttons, and menu commands to it. See my previous post from 
> this afternoon.
> -- 
> Charles Kenyon
> 
> Word New User FAQ & Web Directory: http://addbalance.com/word
> 
> Intermediate User's Guide to Microsoft Word (supplemented version of 
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> 
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>  --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
> 
> 
> "jrfloyd"  wrote in message 
> news:E73CD695-E5C3-4F4A-ADDF-A20BA5929DDA@microsoft.com...
> > Ok. The spell check is working if I leave the document protected and I run 
> > it
> > from Visual Basic. Any ideas on how to run this without having to open 
> > Visual
> > Basis but leaving the document protected ?
> >
> > "jrfloyd" wrote:
> >
> >> Yes. Thats the one I have. Also. If I get this one working. how do you 
> >> run
> >> the macro if the form is protected? Should I add it to a run macro on 
> >> exit
> >> field at the end. I wanted to add a toolbar icon but I can not run the 
> >> macro
> >> from the toolbar if the form is prtoected.
> >>
> >> "Charles Kenyon" wrote:
> >>
> >> > We are talking about the macro from
> >> > http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm 
> >> > inserted
> >> > without modification, right?
> >> >
> >> > -- 
> >> > Charles Kenyon
> >> >
> >> > Word New User FAQ & Web Directory: http://addbalance.com/word
> >> >
> >> > Intermediate User's Guide to Microsoft Word (supplemented version of
> >> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >> >
> >> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >> >  --------- --------- --------- --------- --------- ---------
> >> > This message is posted to a newsgroup. Please post replies
> >> > and questions to the newsgroup so that others can learn
> >> > from my ignorance and your wisdom.
> >> > "jrfloyd"  wrote in message
> >> > news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
> >> > > Thanks. I will check those sites. I have seen some of the macros 
> >> > > where it
> >> > > says
> >> > > Active document. Range. Language ID = wdEnglishUS. If it had a line 
> >> > > that
> >> > > would uncheck the do not check spelling and grammer box I think it 
> >> > > would
> >> > > fix
> >> > > my problem. I'm by no means a Word or Macro expert so I don't know 
> >> > > how to
> >> > > add
> >> > > that command or if it would even work. What do you think?
> >> > >
> >> > > "Charles Kenyon" wrote:
> >> > >
> >> > >> Hi,
> >> > >>
> >> > >> 1) Bookmarks are not set to calculate on exit. They are just there 
> >> > >> or not
> >> > >> there. Form fields, which have bookmarks set by default, can be set 
> >> > >> to
> >> > >> calculate on exit.
> >> > >>
> >> > >> 2) A protected form must be protected for the fields to work 
> >> > >> properly. If
> >> > >> you can use Ctrl-A and select something outside of a single field, 
> >> > >> it is
> >> > >> not
> >> > >> protected.
> >> > >>
> >> > >> 3) If you are looking for squiggly red lines to appear as you type 
> >> > >> in a
> >> > >> protected form you are out of luck. It won't happen.
> >> > >>
> >> > >> 4) The macro to check spelling works, but it assumes that you are 
> >> > >> working
> >> > >> with form fields in a document that is protected for forms. You have 
> >> > >> to
> >> > >> call
> >> > >> it when you want to check the spelling.
> >> > >>
> >> > >> What you are talking about is what Word calls an "online form." 
> >> > >> Check
> >> > >> this
> >> > >> in help. For more about online forms, follow the links at
> >> > >> http://addbalance.com/word/wordwebresources.htm#Forms or
> >> > >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm 
> >> > >> especially
> >> > >> Dian
> >> > >> Chapman's series of articles.
> >> > >>
> >> > >> Hope this helps,
> >> > >> -- 
> >> > >>
> >> > >> Charles Kenyon
> >> > >>
> >> > >> Word New User FAQ & Web Directory: http://addbalance.com/word
> >> > >>
> >> > >> Intermediate User's Guide to Microsoft Word (supplemented version of
> >> > >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >> > >>
> >> > >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >> > >>  --------- --------- --------- --------- --------- ---------
> >> > >> This message is posted to a newsgroup. Please post replies
> >> > >> and questions to the newsgroup so that others can learn
> >> > >> from my ignorance and your wisdom.
> >> > >>
> >> > >> "jrfloyd"  wrote in message
> >> > >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
> >> > >> >I have a form with text fields in it. The form is protected. I also 
> >> > >> >have
> >> > >> > bookmarks with matching referance fields. The bookmarks are set to
> >> > >> > calculate
> >> > >> > upon exit. The problem is as soon as the user tabs through one of 
> >> > >> > the
> >> > >> > fields
> >> > >> > it sets the Language setting back to do not spell check for the 
> >> > >> > whole
> >> > >> > document. I have tried the macro on the MVP website and it does 
> >> > >> > not
> >> > >> > work
> >> > >> > because the text fields get set back to not spell check and it 
> >> > >> > does not
> >> > >> > change that. I can get it to spell check if I unprotect the form,
> >> > >> > highlight
> >> > >> > the text, go to the language setting and uncheck the do not spell
> >> > >> > check.
> >> > >> > But
> >> > >> > that has to be done on every text field I want to spell check on 
> >> > >> > every
> >> > >> > time I
> >> > >> > use the form. Can a macro be written or modified to do this for 
> >> > >> > me? Or
> >> > >> > is
> >> > >> > there a way to set the document to allow spell check even if it 
> >> > >> > has
> >> > >> > bookmarks
> >> > >> > that calculate on exit. I know its the bookmarks that are the 
> >> > >> > problem
> >> > >> > because
> >> > >> > the document keeps the language setting I give it and spell checks 
> >> > >> > the
> >> > >> > text
> >> > >> > fileds until I add the bookmark and tell it to calculate on exit. 
> >> > >> > I'm
> >> > >> > at
> >> > >> > the
> >> > >> > end of my rope on this so any help would be great. I have already 
> >> > >> > tried
> >> > >> > the
> >> > >> > Cnt A and it doed not work either. I've also tried setting the 
> >> > >> > default
> >> > >> > language with the do not check spelling and auto detect the 
> >> > >> > lanaguage
> >> > >> > boxes
> >> > >> > unchecked. As soon as the activity hour glass displays after you 
> >> > >> > exit a
> >> > >> > bookmark field it sets the do not check grammer or spelling. The 
> >> > >> > check
> >> > >> > bos
> >> > >> > is
> >> > >> > filled in by a green box instead of a check. Not sure what that 
> >> > >> > means.
> >> > >> > I
> >> > >> > am
> >> > >> > running Office 2003.
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> > 
> 
> 
>

You are welcome. It is a long article and it is easy to just grab what looks 
like it applies and skip the rest.

The following may help. 
http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToToolbar.htm, 
http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToHotkey.htm and 
http://word.mvps.org/FAQs/Customization/CustomButtonImages.htm.

You might also name your starter macro ToolsProofing. If you do, it will run 
whenever the F7 key is pressed without your reassigning it. You can replace 
the Spelling and Grammar command on the Tools menu with your macro as well 
(so it will be available). And yes, you can make it an on-exit macro for one 
or more of your fields if you think this is appropriate. Remember, an 
on-exit macro does not get triggered by filling in the field, but by leaving 
it.

Make sure you save any customizations to your template, rather than 
normal.dot. Then distribute your template.

Hope things work out.
-- 
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of 
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"jrfloyd"  wrote in message 
news:963CE65B-4F1A-49D3-B32F-89B068283F22@microsoft.com...
> Ok. Thanks again for your help
>
> "Charles Kenyon" wrote:
>
>> Read the article, the whole article. You can easily run it from the user
>> interface with the document protected. You can set it up so that it is
>> invisible to the user that something special is going on by attaching the 
>> F7
>> key, toolbar buttons, and menu commands to it. See my previous post from
>> this afternoon.
>> -- 
>> Charles Kenyon
>>
>> Word New User FAQ & Web Directory: http://addbalance.com/word
>>
>> Intermediate User's Guide to Microsoft Word (supplemented version of
>> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>>
>> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>>  --------- --------- --------- --------- --------- ---------
>> This message is posted to a newsgroup. Please post replies
>> and questions to the newsgroup so that others can learn
>> from my ignorance and your wisdom.
>>
>>
>> "jrfloyd"  wrote in message
>> news:E73CD695-E5C3-4F4A-ADDF-A20BA5929DDA@microsoft.com...
>> > Ok. The spell check is working if I leave the document protected and I 
>> > run
>> > it
>> > from Visual Basic. Any ideas on how to run this without having to open
>> > Visual
>> > Basis but leaving the document protected ?
>> >
>> > "jrfloyd" wrote:
>> >
>> >> Yes. Thats the one I have. Also. If I get this one working. how do you
>> >> run
>> >> the macro if the form is protected? Should I add it to a run macro on
>> >> exit
>> >> field at the end. I wanted to add a toolbar icon but I can not run the
>> >> macro
>> >> from the toolbar if the form is prtoected.
>> >>
>> >> "Charles Kenyon" wrote:
>> >>
>> >> > We are talking about the macro from
>> >> > http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
>> >> > inserted
>> >> > without modification, right?
>> >> >
>> >> > -- 
>> >> > Charles Kenyon
>> >> >
>> >> > Word New User FAQ & Web Directory: http://addbalance.com/word
>> >> >
>> >> > Intermediate User's Guide to Microsoft Word (supplemented version of
>> >> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >> >
>> >> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> >> >  --------- --------- --------- --------- --------- ---------
>> >> > This message is posted to a newsgroup. Please post replies
>> >> > and questions to the newsgroup so that others can learn
>> >> > from my ignorance and your wisdom.
>> >> > "jrfloyd"  wrote in message
>> >> > news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
>> >> > > Thanks. I will check those sites. I have seen some of the macros
>> >> > > where it
>> >> > > says
>> >> > > Active document. Range. Language ID = wdEnglishUS. If it had a 
>> >> > > line
>> >> > > that
>> >> > > would uncheck the do not check spelling and grammer box I think it
>> >> > > would
>> >> > > fix
>> >> > > my problem. I'm by no means a Word or Macro expert so I don't know
>> >> > > how to
>> >> > > add
>> >> > > that command or if it would even work. What do you think?
>> >> > >
>> >> > > "Charles Kenyon" wrote:
>> >> > >
>> >> > >> Hi,
>> >> > >>
>> >> > >> 1) Bookmarks are not set to calculate on exit. They are just 
>> >> > >> there
>> >> > >> or not
>> >> > >> there. Form fields, which have bookmarks set by default, can be 
>> >> > >> set
>> >> > >> to
>> >> > >> calculate on exit.
>> >> > >>
>> >> > >> 2) A protected form must be protected for the fields to work
>> >> > >> properly. If
>> >> > >> you can use Ctrl-A and select something outside of a single 
>> >> > >> field,
>> >> > >> it is
>> >> > >> not
>> >> > >> protected.
>> >> > >>
>> >> > >> 3) If you are looking for squiggly red lines to appear as you 
>> >> > >> type
>> >> > >> in a
>> >> > >> protected form you are out of luck. It won't happen.
>> >> > >>
>> >> > >> 4) The macro to check spelling works, but it assumes that you are
>> >> > >> working
>> >> > >> with form fields in a document that is protected for forms. You 
>> >> > >> have
>> >> > >> to
>> >> > >> call
>> >> > >> it when you want to check the spelling.
>> >> > >>
>> >> > >> What you are talking about is what Word calls an "online form."
>> >> > >> Check
>> >> > >> this
>> >> > >> in help. For more about online forms, follow the links at
>> >> > >> http://addbalance.com/word/wordwebresources.htm#Forms or
>> >> > >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm
>> >> > >> especially
>> >> > >> Dian
>> >> > >> Chapman's series of articles.
>> >> > >>
>> >> > >> Hope this helps,
>> >> > >> -- 
>> >> > >>
>> >> > >> Charles Kenyon
>> >> > >>
>> >> > >> Word New User FAQ & Web Directory: http://addbalance.com/word
>> >> > >>
>> >> > >> Intermediate User's Guide to Microsoft Word (supplemented version 
>> >> > >> of
>> >> > >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >> > >>
>> >> > >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is 
>> >> > >> awesome!
>> >> > >>  --------- --------- --------- --------- --------- ---------
>> >> > >> This message is posted to a newsgroup. Please post replies
>> >> > >> and questions to the newsgroup so that others can learn
>> >> > >> from my ignorance and your wisdom.
>> >> > >>
>> >> > >> "jrfloyd"  wrote in message
>> >> > >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
>> >> > >> >I have a form with text fields in it. The form is protected. I 
>> >> > >> >also
>> >> > >> >have
>> >> > >> > bookmarks with matching referance fields. The bookmarks are set 
>> >> > >> > to
>> >> > >> > calculate
>> >> > >> > upon exit. The problem is as soon as the user tabs through one 
>> >> > >> > of
>> >> > >> > the
>> >> > >> > fields
>> >> > >> > it sets the Language setting back to do not spell check for the
>> >> > >> > whole
>> >> > >> > document. I have tried the macro on the MVP website and it does
>> >> > >> > not
>> >> > >> > work
>> >> > >> > because the text fields get set back to not spell check and it
>> >> > >> > does not
>> >> > >> > change that. I can get it to spell check if I unprotect the 
>> >> > >> > form,
>> >> > >> > highlight
>> >> > >> > the text, go to the language setting and uncheck the do not 
>> >> > >> > spell
>> >> > >> > check.
>> >> > >> > But
>> >> > >> > that has to be done on every text field I want to spell check 
>> >> > >> > on
>> >> > >> > every
>> >> > >> > time I
>> >> > >> > use the form. Can a macro be written or modified to do this for
>> >> > >> > me? Or
>> >> > >> > is
>> >> > >> > there a way to set the document to allow spell check even if it
>> >> > >> > has
>> >> > >> > bookmarks
>> >> > >> > that calculate on exit. I know its the bookmarks that are the
>> >> > >> > problem
>> >> > >> > because
>> >> > >> > the document keeps the language setting I give it and spell 
>> >> > >> > checks
>> >> > >> > the
>> >> > >> > text
>> >> > >> > fileds until I add the bookmark and tell it to calculate on 
>> >> > >> > exit.
>> >> > >> > I'm
>> >> > >> > at
>> >> > >> > the
>> >> > >> > end of my rope on this so any help would be great. I have 
>> >> > >> > already
>> >> > >> > tried
>> >> > >> > the
>> >> > >> > Cnt A and it doed not work either. I've also tried setting the
>> >> > >> > default
>> >> > >> > language with the do not check spelling and auto detect the
>> >> > >> > lanaguage
>> >> > >> > boxes
>> >> > >> > unchecked. As soon as the activity hour glass displays after 
>> >> > >> > you
>> >> > >> > exit a
>> >> > >> > bookmark field it sets the do not check grammer or spelling. 
>> >> > >> > The
>> >> > >> > check
>> >> > >> > bos
>> >> > >> > is
>> >> > >> > filled in by a green box instead of a check. Not sure what that
>> >> > >> > means.
>> >> > >> > I
>> >> > >> > am
>> >> > >> > running Office 2003.
>> >> > >> >
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>
>>
>>

Ok. I think I have won the battle now. I was able to get everything working 
and I created an icon on the toolbar to unprotect, spell check, and reprotect 
my document. I got handed this project after it was already started so I was 
driving blind. I'm by no means a Word expert. You have really helped me out. 
I along with all the folks that will be using this really appreciate all your 
help.

"Charles Kenyon" wrote:

> You are welcome. It is a long article and it is easy to just grab what looks 
> like it applies and skip the rest.
> 
> The following may help. 
> http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToToolbar.htm, 
> http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToHotkey.htm and 
> http://word.mvps.org/FAQs/Customization/CustomButtonImages.htm.
> 
> You might also name your starter macro ToolsProofing. If you do, it will run 
> whenever the F7 key is pressed without your reassigning it. You can replace 
> the Spelling and Grammar command on the Tools menu with your macro as well 
> (so it will be available). And yes, you can make it an on-exit macro for one 
> or more of your fields if you think this is appropriate. Remember, an 
> on-exit macro does not get triggered by filling in the field, but by leaving 
> it.
> 
> Make sure you save any customizations to your template, rather than 
> normal.dot. Then distribute your template.
> 
> Hope things work out.
> -- 
> Charles Kenyon
> 
> Word New User FAQ & Web Directory: http://addbalance.com/word
> 
> Intermediate User's Guide to Microsoft Word (supplemented version of 
> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> 
> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>  --------- --------- --------- --------- --------- ---------
> This message is posted to a newsgroup. Please post replies
> and questions to the newsgroup so that others can learn
> from my ignorance and your wisdom.
> 
> 
> "jrfloyd"  wrote in message 
> news:963CE65B-4F1A-49D3-B32F-89B068283F22@microsoft.com...
> > Ok. Thanks again for your help
> >
> > "Charles Kenyon" wrote:
> >
> >> Read the article, the whole article. You can easily run it from the user
> >> interface with the document protected. You can set it up so that it is
> >> invisible to the user that something special is going on by attaching the 
> >> F7
> >> key, toolbar buttons, and menu commands to it. See my previous post from
> >> this afternoon.
> >> -- 
> >> Charles Kenyon
> >>
> >> Word New User FAQ & Web Directory: http://addbalance.com/word
> >>
> >> Intermediate User's Guide to Microsoft Word (supplemented version of
> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >>
> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >>  --------- --------- --------- --------- --------- ---------
> >> This message is posted to a newsgroup. Please post replies
> >> and questions to the newsgroup so that others can learn
> >> from my ignorance and your wisdom.
> >>
> >>
> >> "jrfloyd"  wrote in message
> >> news:E73CD695-E5C3-4F4A-ADDF-A20BA5929DDA@microsoft.com...
> >> > Ok. The spell check is working if I leave the document protected and I 
> >> > run
> >> > it
> >> > from Visual Basic. Any ideas on how to run this without having to open
> >> > Visual
> >> > Basis but leaving the document protected ?
> >> >
> >> > "jrfloyd" wrote:
> >> >
> >> >> Yes. Thats the one I have. Also. If I get this one working. how do you
> >> >> run
> >> >> the macro if the form is protected? Should I add it to a run macro on
> >> >> exit
> >> >> field at the end. I wanted to add a toolbar icon but I can not run the
> >> >> macro
> >> >> from the toolbar if the form is prtoected.
> >> >>
> >> >> "Charles Kenyon" wrote:
> >> >>
> >> >> > We are talking about the macro from
> >> >> > http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
> >> >> > inserted
> >> >> > without modification, right?
> >> >> >
> >> >> > -- 
> >> >> > Charles Kenyon
> >> >> >
> >> >> > Word New User FAQ & Web Directory: http://addbalance.com/word
> >> >> >
> >> >> > Intermediate User's Guide to Microsoft Word (supplemented version of
> >> >> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >> >> >
> >> >> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
> >> >> >  --------- --------- --------- --------- --------- ---------
> >> >> > This message is posted to a newsgroup. Please post replies
> >> >> > and questions to the newsgroup so that others can learn
> >> >> > from my ignorance and your wisdom.
> >> >> > "jrfloyd"  wrote in message
> >> >> > news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
> >> >> > > Thanks. I will check those sites. I have seen some of the macros
> >> >> > > where it
> >> >> > > says
> >> >> > > Active document. Range. Language ID = wdEnglishUS. If it had a 
> >> >> > > line
> >> >> > > that
> >> >> > > would uncheck the do not check spelling and grammer box I think it
> >> >> > > would
> >> >> > > fix
> >> >> > > my problem. I'm by no means a Word or Macro expert so I don't know
> >> >> > > how to
> >> >> > > add
> >> >> > > that command or if it would even work. What do you think?
> >> >> > >
> >> >> > > "Charles Kenyon" wrote:
> >> >> > >
> >> >> > >> Hi,
> >> >> > >>
> >> >> > >> 1) Bookmarks are not set to calculate on exit. They are just 
> >> >> > >> there
> >> >> > >> or not
> >> >> > >> there. Form fields, which have bookmarks set by default, can be 
> >> >> > >> set
> >> >> > >> to
> >> >> > >> calculate on exit.
> >> >> > >>
> >> >> > >> 2) A protected form must be protected for the fields to work
> >> >> > >> properly. If
> >> >> > >> you can use Ctrl-A and select something outside of a single 
> >> >> > >> field,
> >> >> > >> it is
> >> >> > >> not
> >> >> > >> protected.
> >> >> > >>
> >> >> > >> 3) If you are looking for squiggly red lines to appear as you 
> >> >> > >> type
> >> >> > >> in a
> >> >> > >> protected form you are out of luck. It won't happen.
> >> >> > >>
> >> >> > >> 4) The macro to check spelling works, but it assumes that you are
> >> >> > >> working
> >> >> > >> with form fields in a document that is protected for forms. You 
> >> >> > >> have
> >> >> > >> to
> >> >> > >> call
> >> >> > >> it when you want to check the spelling.
> >> >> > >>
> >> >> > >> What you are talking about is what Word calls an "online form."
> >> >> > >> Check
> >> >> > >> this
> >> >> > >> in help. For more about online forms, follow the links at
> >> >> > >> http://addbalance.com/word/wordwebresources.htm#Forms or
> >> >> > >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm
> >> >> > >> especially
> >> >> > >> Dian
> >> >> > >> Chapman's series of articles.
> >> >> > >>
> >> >> > >> Hope this helps,
> >> >> > >> -- 
> >> >> > >>
> >> >> > >> Charles Kenyon
> >> >> > >>
> >> >> > >> Word New User FAQ & Web Directory: http://addbalance.com/word
> >> >> > >>
> >> >> > >> Intermediate User's Guide to Microsoft Word (supplemented version 
> >> >> > >> of
> >> >> > >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
> >> >> > >>
> >> >> > >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is 
> >> >> > >> awesome!
> >> >> > >>  --------- --------- --------- --------- --------- ---------
> >> >> > >> This message is posted to a newsgroup. Please post replies
> >> >> > >> and questions to the newsgroup so that others can learn
> >> >> > >> from my ignorance and your wisdom.
> >> >> > >>
> >> >> > >> "jrfloyd"  wrote in message
> >> >> > >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
> >> >> > >> >I have a form with text fields in it. The form is protected. I 
> >> >> > >> >also
> >> >> > >> >have
> >> >> > >> > bookmarks with matching referance fields. The bookmarks are set 
> >> >> > >> > to
> >> >> > >> > calculate
> >> >> > >> > upon exit. The problem is as soon as the user tabs through one 
> >> >> > >> > of
> >> >> > >> > the
> >> >> > >> > fields
> >> >> > >> > it sets the Language setting back to do not spell check for the
> >> >> > >> > whole
> >> >> > >> > document. I have tried the macro on the MVP website and it does
> >> >> > >> > not
> >> >> > >> > work
> >> >> > >> > because the text fields get set back to not spell check and it
> >> >> > >> > does not
> >> >> > >> > change that. I can get it to spell check if I unprotect the 
> >> >> > >> > form,
> >> >> > >> > highlight
> >> >> > >> > the text, go to the language setting and uncheck the do not 
> >> >> > >> > spell
> >> >> > >> > check.
> >> >> > >> > But
> >> >> > >> > that has to be done on every text field I want to spell check 
> >> >> > >> > on
> >> >> > >> > every
> >> >> > >> > time I
> >> >> > >> > use the form. Can a macro be written or modified to do this for
> >> >> > >> > me? Or
> >> >> > >> > is
> >> >> > >> > there a way to set the document to allow spell check even if it
> >> >> > >> > has
> >> >> > >> > bookmarks
> >> >> > >> > that calculate on exit. I know its the bookmarks that are the
> >> >> > >> > problem
> >> >> > >> > because
> >> >> > >> > the document keeps the language setting I give it and spell 
> >> >> > >> > checks
> >> >> > >> > the
> >> >> > >> > text
> >> >> > >> > fileds until I add the bookmark and tell it to calculate on 
> >> >> > >> > exit.
> >> >> > >> > I'm
> >> >> > >> > at
> >> >> > >> > the
> >> >> > >> > end of my rope on this so any help would be great. I have 
> >> >> > >> > already
> >> >> > >> > tried
> >> >> > >> > the
> >> >> > >> > Cnt A and it doed not work either. I've also tried setting the
> >> >> > >> > default
> >> >> > >> > language with the do not check spelling and auto detect the
> >> >> > >> > lanaguage
> >> >> > >> > boxes
> >> >> > >> > unchecked. As soon as the activity hour glass displays after 
> >> >> > >> > you
> >> >> > >> > exit a
> >> >> > >> > bookmark field it sets the do not check grammer or spelling. 
> >> >> > >> > The
> >> >> > >> > check
> >> >> > >> > bos
> >> >> > >> > is
> >> >> > >> > filled in by a green box instead of a check. Not sure what that
> >> >> > >> > means.
> >> >> > >> > I
> >> >> > >> > am
> >> >> > >> > running Office 2003.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >> 
> 
> 
>

You're welcome. Glad to know you got up and running.
-- 
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of 
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
 --------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"jrfloyd"  wrote in message 
news:B880B93A-9563-4646-862B-7BBC3FFB9B8E@microsoft.com...
> Ok. I think I have won the battle now. I was able to get everything 
> working
> and I created an icon on the toolbar to unprotect, spell check, and 
> reprotect
> my document. I got handed this project after it was already started so I 
> was
> driving blind. I'm by no means a Word expert. You have really helped me 
> out.
> I along with all the folks that will be using this really appreciate all 
> your
> help.
>
> "Charles Kenyon" wrote:
>
>> You are welcome. It is a long article and it is easy to just grab what 
>> looks
>> like it applies and skip the rest.
>>
>> The following may help.
>> http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToToolbar.htm,
>> http://word.mvps.org/FAQs/Customization/AsgnCmdOrMacroToHotkey.htm and
>> http://word.mvps.org/FAQs/Customization/CustomButtonImages.htm.
>>
>> You might also name your starter macro ToolsProofing. If you do, it will 
>> run
>> whenever the F7 key is pressed without your reassigning it. You can 
>> replace
>> the Spelling and Grammar command on the Tools menu with your macro as 
>> well
>> (so it will be available). And yes, you can make it an on-exit macro for 
>> one
>> or more of your fields if you think this is appropriate. Remember, an
>> on-exit macro does not get triggered by filling in the field, but by 
>> leaving
>> it.
>>
>> Make sure you save any customizations to your template, rather than
>> normal.dot. Then distribute your template.
>>
>> Hope things work out.
>> -- 
>> Charles Kenyon
>>
>> Word New User FAQ & Web Directory: http://addbalance.com/word
>>
>> Intermediate User's Guide to Microsoft Word (supplemented version of
>> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>>
>> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>>  --------- --------- --------- --------- --------- ---------
>> This message is posted to a newsgroup. Please post replies
>> and questions to the newsgroup so that others can learn
>> from my ignorance and your wisdom.
>>
>>
>> "jrfloyd"  wrote in message
>> news:963CE65B-4F1A-49D3-B32F-89B068283F22@microsoft.com...
>> > Ok. Thanks again for your help
>> >
>> > "Charles Kenyon" wrote:
>> >
>> >> Read the article, the whole article. You can easily run it from the 
>> >> user
>> >> interface with the document protected. You can set it up so that it is
>> >> invisible to the user that something special is going on by attaching 
>> >> the
>> >> F7
>> >> key, toolbar buttons, and menu commands to it. See my previous post 
>> >> from
>> >> this afternoon.
>> >> -- 
>> >> Charles Kenyon
>> >>
>> >> Word New User FAQ & Web Directory: http://addbalance.com/word
>> >>
>> >> Intermediate User's Guide to Microsoft Word (supplemented version of
>> >> Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >>
>> >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
>> >>  --------- --------- --------- --------- --------- ---------
>> >> This message is posted to a newsgroup. Please post replies
>> >> and questions to the newsgroup so that others can learn
>> >> from my ignorance and your wisdom.
>> >>
>> >>
>> >> "jrfloyd"  wrote in message
>> >> news:E73CD695-E5C3-4F4A-ADDF-A20BA5929DDA@microsoft.com...
>> >> > Ok. The spell check is working if I leave the document protected and 
>> >> > I
>> >> > run
>> >> > it
>> >> > from Visual Basic. Any ideas on how to run this without having to 
>> >> > open
>> >> > Visual
>> >> > Basis but leaving the document protected ?
>> >> >
>> >> > "jrfloyd" wrote:
>> >> >
>> >> >> Yes. Thats the one I have. Also. If I get this one working. how do 
>> >> >> you
>> >> >> run
>> >> >> the macro if the form is protected? Should I add it to a run macro 
>> >> >> on
>> >> >> exit
>> >> >> field at the end. I wanted to add a toolbar icon but I can not run 
>> >> >> the
>> >> >> macro
>> >> >> from the toolbar if the form is prtoected.
>> >> >>
>> >> >> "Charles Kenyon" wrote:
>> >> >>
>> >> >> > We are talking about the macro from
>> >> >> > http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm
>> >> >> > inserted
>> >> >> > without modification, right?
>> >> >> >
>> >> >> > -- 
>> >> >> > Charles Kenyon
>> >> >> >
>> >> >> > Word New User FAQ & Web Directory: http://addbalance.com/word
>> >> >> >
>> >> >> > Intermediate User's Guide to Microsoft Word (supplemented version 
>> >> >> > of
>> >> >> > Microsoft's Legal Users' Guide) http://addbalance.com/usersguide
>> >> >> >
>> >> >> > See also the MVP FAQ: http://word.mvps.org/FAQs/ which is 
>> >> >> > awesome!
>> >> >> >  --------- --------- --------- --------- --------- ---------
>> >> >> > This message is posted to a newsgroup. Please post replies
>> >> >> > and questions to the newsgroup so that others can learn
>> >> >> > from my ignorance and your wisdom.
>> >> >> > "jrfloyd"  wrote in message
>> >> >> > news:1C7FE7D5-73AB-468D-8FC9-60469536C715@microsoft.com...
>> >> >> > > Thanks. I will check those sites. I have seen some of the 
>> >> >> > > macros
>> >> >> > > where it
>> >> >> > > says
>> >> >> > > Active document. Range. Language ID = wdEnglishUS. If it had a
>> >> >> > > line
>> >> >> > > that
>> >> >> > > would uncheck the do not check spelling and grammer box I think 
>> >> >> > > it
>> >> >> > > would
>> >> >> > > fix
>> >> >> > > my problem. I'm by no means a Word or Macro expert so I don't 
>> >> >> > > know
>> >> >> > > how to
>> >> >> > > add
>> >> >> > > that command or if it would even work. What do you think?
>> >> >> > >
>> >> >> > > "Charles Kenyon" wrote:
>> >> >> > >
>> >> >> > >> Hi,
>> >> >> > >>
>> >> >> > >> 1) Bookmarks are not set to calculate on exit. They are just
>> >> >> > >> there
>> >> >> > >> or not
>> >> >> > >> there. Form fields, which have bookmarks set by default, can 
>> >> >> > >> be
>> >> >> > >> set
>> >> >> > >> to
>> >> >> > >> calculate on exit.
>> >> >> > >>
>> >> >> > >> 2) A protected form must be protected for the fields to work
>> >> >> > >> properly. If
>> >> >> > >> you can use Ctrl-A and select something outside of a single
>> >> >> > >> field,
>> >> >> > >> it is
>> >> >> > >> not
>> >> >> > >> protected.
>> >> >> > >>
>> >> >> > >> 3) If you are looking for squiggly red lines to appear as you
>> >> >> > >> type
>> >> >> > >> in a
>> >> >> > >> protected form you are out of luck. It won't happen.
>> >> >> > >>
>> >> >> > >> 4) The macro to check spelling works, but it assumes that you 
>> >> >> > >> are
>> >> >> > >> working
>> >> >> > >> with form fields in a document that is protected for forms. 
>> >> >> > >> You
>> >> >> > >> have
>> >> >> > >> to
>> >> >> > >> call
>> >> >> > >> it when you want to check the spelling.
>> >> >> > >>
>> >> >> > >> What you are talking about is what Word calls an "online 
>> >> >> > >> form."
>> >> >> > >> Check
>> >> >> > >> this
>> >> >> > >> in help. For more about online forms, follow the links at
>> >> >> > >> http://addbalance.com/word/wordwebresources.htm#Forms or
>> >> >> > >> http://word.mvps.org/FAQs/Customization/FillinTheBlanks.htm
>> >> >> > >> especially
>> >> >> > >> Dian
>> >> >> > >> Chapman's series of articles.
>> >> >> > >>
>> >> >> > >> Hope this helps,
>> >> >> > >> -- 
>> >> >> > >>
>> >> >> > >> Charles Kenyon
>> >> >> > >>
>> >> >> > >> Word New User FAQ & Web Directory: http://addbalance.com/word
>> >> >> > >>
>> >> >> > >> Intermediate User's Guide to Microsoft Word (supplemented 
>> >> >> > >> version
>> >> >> > >> of
>> >> >> > >> Microsoft's Legal Users' Guide) 
>> >> >> > >> http://addbalance.com/usersguide
>> >> >> > >>
>> >> >> > >> See also the MVP FAQ: http://word.mvps.org/FAQs/ which is
>> >> >> > >> awesome!
>> >> >> > >>  --------- --------- --------- --------- --------- ---------
>> >> >> > >> This message is posted to a newsgroup. Please post replies
>> >> >> > >> and questions to the newsgroup so that others can learn
>> >> >> > >> from my ignorance and your wisdom.
>> >> >> > >>
>> >> >> > >> "jrfloyd"  wrote in message
>> >> >> > >> news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@microsoft.com...
>> >> >> > >> >I have a form with text fields in it. The form is protected. 
>> >> >> > >> >I
>> >> >> > >> >also
>> >> >> > >> >have
>> >> >> > >> > bookmarks with matching referance fields. The bookmarks are 
>> >> >> > >> > set
>> >> >> > >> > to
>> >> >> > >> > calculate
>> >> >> > >> > upon exit. The problem is as soon as the user tabs through 
>> >> >> > >> > one
>> >> >> > >> > of
>> >> >> > >> > the
>> >> >> > >> > fields
>> >> >> > >> > it sets the Language setting back to do not spell check for 
>> >> >> > >> > the
>> >> >> > >> > whole
>> >> >> > >> > document. I have tried the macro on the MVP website and it 
>> >> >> > >> > does
>> >> >> > >> > not
>> >> >> > >> > work
>> >> >> > >> > because the text fields get set back to not spell check and 
>> >> >> > >> > it
>> >> >> > >> > does not
>> >> >> > >> > change that. I can get it to spell check if I unprotect the
>> >> >> > >> > form,
>> >> >> > >> > highlight
>> >> >> > >> > the text, go to the language setting and uncheck the do not
>> >> >> > >> > spell
>> >> >> > >> > check.
>> >> >> > >> > But
>> >> >> > >> > that has to be done on every text field I want to spell 
>> >> >> > >> > check
>> >> >> > >> > on
>> >> >> > >> > every
>> >> >> > >> > time I
>> >> >> > >> > use the form. Can a macro be written or modified to do this 
>> >> >> > >> > for
>> >> >> > >> > me? Or
>> >> >> > >> > is
>> >> >> > >> > there a way to set the document to allow spell check even if 
>> >> >> > >> > it
>> >> >> > >> > has
>> >> >> > >> > bookmarks
>> >> >> > >> > that calculate on exit. I know its the bookmarks that are 
>> >> >> > >> > the
>> >> >> > >> > problem
>> >> >> > >> > because
>> >> >> > >> > the document keeps the language setting I give it and spell
>> >> >> > >> > checks
>> >> >> > >> > the
>> >> >> > >> > text
>> >> >> > >> > fileds until I add the bookmark and tell it to calculate on
>> >> >> > >> > exit.
>> >> >> > >> > I'm
>> >> >> > >> > at
>> >> >> > >> > the
>> >> >> > >> > end of my rope on this so any help would be great. I have
>> >> >> > >> > already
>> >> >> > >> > tried
>> >> >> > >> > the
>> >> >> > >> > Cnt A and it doed not work either. I've also tried setting 
>> >> >> > >> > the
>> >> >> > >> > default
>> >> >> > >> > language with the do not check spelling and auto detect the
>> >> >> > >> > lanaguage
>> >> >> > >> > boxes
>> >> >> > >> > unchecked. As soon as the activity hour glass displays after
>> >> >> > >> > you
>> >> >> > >> > exit a
>> >> >> > >> > bookmark field it sets the do not check grammer or spelling.
>> >> >> > >> > The
>> >> >> > >> > check
>> >> >> > >> > bos
>> >> >> > >> > is
>> >> >> > >> > filled in by a green box instead of a check. Not sure what 
>> >> >> > >> > that
>> >> >> > >> > means.
>> >> >> > >> > I
>> >> >> > >> > am
>> >> >> > >> > running Office 2003.
>> >> >> > >> >
>> >> >> > >>
>> >> >> > >>
>> >> >> > >>
>> >> >> >
>> >> >> >
>> >> >> >
>> >>
>> >>
>> >>
>>
>>
>>