spellcheck in protected form

[Guest]

I have tried the macro posted but I can't figure it out for the life of me,
it just won't work. I have spent 2 days on it and am fed up! I am creating
a password protected form for people to use. They need spellcheck for the
filled in blanks only. I am the only one with the password that can change
the form. Can someone please do it for me so I don't have to worry about it
any more. I just want it to work!!!! I know how to do very simple macros
only. I want it to work on other computers where the people will be filling
it out.

We are using Word 2003.

 

[Charles Kenyon]

I assume you mean the macro at
http://www.mvps.org/word/FAQs/MacrosVBA/SpellcheckProtectDoc.htm.
You need to add your password to the reprotection command.

'Re-protect the document
oDoc.Protect Type:=wdAllowOnlyFormFields, NoReset:=True

With a password:
'Re-protect the document
oDoc.Protect Type:=wdAllowOnlyFormFields, NoReset:=True,
Password:="MyPassword"

Replace the MyPassword between the quotation marks with your password. Note,
that should all be one line.
--
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


--------- --------- --------- --------- --------- ---------
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.

 

[Charles Kenyon]

Oops, you will also need the password in the unprotect statement.

'Now unprotect the document
oDoc.Unprotect

should be:

'Now unprotect the document
oDoc.Unprotect Password:="MyPassword"
--
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


--------- --------- --------- --------- --------- ---------
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.