Saving file with restricted editing

[dcmontva]

Hi,



I am currently putting together a form in Word with a submit button. Everything is working as it should be, apart from when I save the form with restricted editing - filling in forms, the submit button no longer works when I re-open the file. The code from the button has gone. I have saved the file as a macro enabled template, and I need to have restricted editing on the form so that it can only be filled out by the user. Is this problem being caused by the restricted editing, or am I doing something wrong?

Hope you can help

[Charles Kenyon]

Does the button work if you do not restrict editing or end the restriction?
Filling in Forms is a VERY restrictive method of protection intended for use with legacy form fields.


Consider the protection method of "No Changes" with exceptions. Make areas you want the user to be able to edit exceptions for everyone.
Create a Form Using Word Content Controls by Greg Maxey, MVP

[dcmontva]

Hi

Thanks for getting back to me so quickly!
Yes, the submit button works fine without any restrictions in place.
I will check out the link you posted and try the method you suggested.
I'll post back with the results!

Many thanks

[dcmontva]

Hi,
I have tried the methods you suggested and everything works fine. Thanks!

I do have one question.

When I click the submit button it automatically opens Outlook, which for me is great. But what happens if a user doesn't have Outlook installed on their pc?

In the code can I edit it so that it just says "application" rather than "Outlook.application". Or will that not work?

[Charles Kenyon]

If it is well written, it either opens the default mail program on the user's PC or it does nothing. It depends on the code of your button.

[macropod]

Code that uses Outlook.Application to initiate the email will only work with Outlook installed, but it isn't necessary for Outlook to be the default mail program. An alternative approach that should work on any Windows system, is to leverage the Windows Mail-API (aka MAPI). For some code to get you started on that, see:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=311
See also:
http://www.vb-helper.com/howto_excel..._students.html