Microsoft Office Forums Saving file with restricted editing

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2019, 01:21 PM
dcmontva dcmontva is offline Saving file with restricted editing Windows 10 Saving file with restricted editing Office 2016
Novice
Saving file with restricted editing
 
Join Date: Apr 2019
Location: UK
Posts: 4
dcmontva is on a distinguished road
Default Saving file with restricted editing

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
Reply With Quote
  #2  
Old 04-28-2019, 01:58 PM
Charles Kenyon Charles Kenyon is offline Saving file with restricted editing Windows 10 Saving file with restricted editing Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,949
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

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
Reply With Quote
  #3  
Old 04-28-2019, 02:02 PM
dcmontva dcmontva is offline Saving file with restricted editing Windows 10 Saving file with restricted editing Office 2016
Novice
Saving file with restricted editing
 
Join Date: Apr 2019
Location: UK
Posts: 4
dcmontva is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 04-29-2019, 10:53 AM
dcmontva dcmontva is offline Saving file with restricted editing Windows 10 Saving file with restricted editing Office 2016
Novice
Saving file with restricted editing
 
Join Date: Apr 2019
Location: UK
Posts: 4
dcmontva is on a distinguished road
Default

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?
Reply With Quote
  #5  
Old 04-29-2019, 11:56 AM
Charles Kenyon Charles Kenyon is offline Saving file with restricted editing Windows 10 Saving file with restricted editing Office 2016
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 5,949
Charles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to allCharles Kenyon is a name known to all
Default

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.
Reply With Quote
  #6  
Old 04-29-2019, 05:01 PM
macropod's Avatar
macropod macropod is offline Saving file with restricted editing Windows 7 64bit Saving file with restricted editing Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,543
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Restricted Editing works for most but not one... dmcanallen Word 0 08-04-2017 10:15 AM
Saving file with restricted editing Restricted editing disables macro tne22727 Word VBA 1 10-29-2014 02:01 PM
Specifying a user in restricted editing Ulodesk Word 2 05-24-2014 12:09 PM
Saving file with restricted editing Highlighting from Restricted Editing Invicta Word 3 11-08-2012 06:05 AM
Saving file with restricted editing Restricted Formatting & Editing dani Word 1 11-08-2012 01:09 AM


All times are GMT -7. The time now is 09:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft