command button protected document - Word 2010

Question

Hello

I have added a command button and using the click event. The document is restricted from editing allowing the user to fill in the form fields. The goal is to make it easier for the user to send the document to a specific address after the form fields are complete. This works as designed if the document is not protected. When protected, the button does not execute for some users. Some users can click and hold the button to get execution of the code.

What can is the best way to create submission process for our users?

Private Sub CommandButton1_Click()

ActiveDocument.SendForReview _

Recipients:=MyAddress@Microsoft.com, _

Subject:="Hydralada Maxi Quote", _

ShowMessage:=True, _

IncludeAttachment:=True

MsgBox "Your Message has been sent!"

End Sub

Answer 1

What I have done is to create separate sections for protected and unprotected parts of the document.  When you turn protection on (Developer tab => Protect section => Restrict Editing button), you can select which sections to protect (unprotect the section containing [just] the button ).  This allowed me to embed documents into my document in that section.

Answer 2

No. There is no validation of the form fields. The button is at the end of the document outside a table. Just a Submit macro:

Private Sub CommandButton1_Click()

ActiveDocument.SendForReview _

Recipients:=MyAddress@Microsoft.com, _

Subject:="Hydralada Maxi Quote", _

ShowMessage:=True, _

IncludeAttachment:=True

MsgBox "Your Message has been sent!"

End Sub

Answer 3

Are you using the macrobutton to run a macro that contains the necessary code to validate that the necessary formfields have data entered into them and if so the email the document?

Answer 4

Thank you Doug.

I added the MacroButton field. I am getting the same behavior as the Command Button. When the user clicks on the MacroButton or the Command Button, the focus jumps to the first field in the document. Is there a tab order - Focus issue - or a specific location that these controls need to added?

Damon

Answer 5

See the article "Using MacroButton fields” at:

http://www.word.mvps.org/FAQs/TblsFldsFms/UsingMacroButton.htm