Re: Spell Check Protected Form with Bookmarks

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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" <jrfloyd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:963CE65B-4F1A-49D3-B32F-89B068283F22@xxxxxxxxxxxxxxxx
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" <jrfloyd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E73CD695-E5C3-4F4A-ADDF-A20BA5929DDA@xxxxxxxxxxxxxxxx
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" <jrfloyd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1C7FE7D5-73AB-468D-8FC9-60469536C715@xxxxxxxxxxxxxxxx
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" <jrfloyd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D9D6A2AE-CE3D-4AB4-ACB9-A27D0FBF29DA@xxxxxxxxxxxxxxxx
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.












.

Quantcast