 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Document Management / February 2006spellcheck in protected form
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. 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.  SignatureCharles 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. >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 [quoted text clipped - 10 lines] > > We are using Word 2003. 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" SignatureCharles 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. >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 [quoted text clipped - 10 lines] > > We are using Word 2003. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.