Is there a way to keep from loosing information in Word form fields when shifting from unprotect to protect back again to unprotected? The form is in a table. I have a Word form that is filled out by a field office and emailed to headquarters. Headquarters then reviews the form and if necessary makes changes. After the review the information from the form is placed in a database. My plan is to have a menu button with the macro that updates the database. I haven't written the update process yet. Since I'm new to the VBA stuff I'm doing a little testing to learn how to associated the button with the activeDocument. I've grabbed some code from the Internet that does selects cells. This works fine, but to get it to work I have to unprotect the form. I don't want (if possible) to have the user unprotect the form to update the database and then remember to NOT protect the form again. But if they do I want to make sure the information is not lost. Is this possible? Actually is it possible to do the above without messing with the protect/unprotect stuff. That is, headquarters reviews the form and makes changes (if necessary) and then executes the database update macro. Hope I made a littel sense. Mike
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
