Thank you & Notes about Macro for SpellChecking Form

[cristyh]

Thank you so much to all of you who help with the troubleshooting on this
site. I was able to get my form to spellcheck correctly with the suggested
macro and using other notes I read about making it work. Thanks for the
patience and help!

I am using a form a little bit differently than some others that have posted
questions (I do transcription work and want the entering part to be as easy
as possible), but I thought I'd offer a few notes I discovered while trying
to make it work for me (& I know these are detailed in other strings, too -
If I'm incorrect on any, please let me know):
- If you don't already have the Forms toolbar visible, select it on the
View|Toolbars menu - protecting and unprotecting is then just a click on the
lock icon
- You have to unprotect the doc (deselect the lock icon) to create the new
macro
- Make sure you select & delete everything that's already in the macro window
- If you copy the macro from the suggested website at:
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm - you'll need to
either remove the separating lines (lines with a bunch of dashes "---") or
put a single apostrophe before each of them to include them in the comments "
'--------" or it'll give you an error
- After you reprotect your doc and the users enter info, you'll have to
unprotect the doc again to run the macro (Tools|Macro|Macros then "Run")

Thanks!

 

[Jay Freedman]

Thank you so much to all of you who help with the troubleshooting on
this site. I was able to get my form to spellcheck correctly with
the suggested macro and using other notes I read about making it
work. Thanks for the patience and help!

I am using a form a little bit differently than some others that have
posted questions (I do transcription work and want the entering part
to be as easy as possible), but I thought I'd offer a few notes I
discovered while trying to make it work for me (& I know these are
detailed in other strings, too - If I'm incorrect on any, please let
me know): - If you don't already have the Forms toolbar visible,
select it on the View|Toolbars menu - protecting and unprotecting is
then just a click on the lock icon
- You have to unprotect the doc (deselect the lock icon) to create
the new macro
- Make sure you select & delete everything that's already in the
macro window
- If you copy the macro from the suggested website at:
http://word.mvps.org/FAQs/MacrosVBA/SpellcheckProtectDoc.htm - you'll
need to either remove the separating lines (lines with a bunch of
dashes "---") or put a single apostrophe before each of them to
include them in the comments " '--------" or it'll give you an error
- After you reprotect your doc and the users enter info, you'll have
to unprotect the doc again to run the macro (Tools|Macro|Macros then
"Run")

Thanks!

Just a comment on your last item:

It may *seem* that you have to unprotect the document to run the macro,
because the Tools > Macro > Macros command and its Alt+F8 shortcut are
disabled when the document is protected.

However, if you follow the suggestion in item 3 near the bottom of the
SpellCheckProtectDoc.htm web page to place a button on the toolbar (and make
sure the button is saved in the form template, not in the Normal.dot
template), then all you need to do is click the button. The macro itself has
code to take care of unprotecting and reprotecting the document -- in fact,
that's the whole point of having the macro, rather than manually
unprotecting and then pressing F7 to spell check.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[cristyh]

I didn't understand how to implement your suggestion below until I did a
little more research. It is now working wonderfully. Thanks for your help!