Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-28-2023, 04:59 PM
Guessed's Avatar
Guessed Guessed is offline Enable Editing for "Protected View" documents automatically? (in order to run AutoOpen macros) Windows 10 Enable Editing for "Protected View" documents automatically? (in order to run AutoOpen macros) Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

The way a corporate user would enable macros is to place the vba in a template which can be pre-loaded to the user machines so that the code is already trusted. Then your documents don't need to contain any code but they have that template set as the attached template.

Because the code is then coming from a trusted location, it can run without requiring 'enabling' or unblocking.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #2  
Old 08-29-2023, 01:04 PM
Italophile Italophile is online now Enable Editing for "Protected View" documents automatically? (in order to run AutoOpen macros) Windows 11 Enable Editing for "Protected View" documents automatically? (in order to run AutoOpen macros) Office 2021
Expert
 
Join Date: Mar 2022
Posts: 563
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Quote:
Originally Posted by Guessed View Post
The way a corporate user would enable macros is to place the vba in a template which can be pre-loaded to the user machines so that the code is already trusted. Then your documents don't need to contain any code but they have that template set as the attached template.

Because the code is then coming from a trusted location, it can run without requiring 'enabling' or unblocking.
The message is related to the origin of the files, not that they contain macros. Documents received by email or downloaded from the internet are automatically blocked for editing regardless of whether they contain code. When opened for the first time Word displays the message included in the initial post.
Reply With Quote
Reply

Tags
enable editing, protected view



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting Caption: "Protects Documents" prevents Editing Phil Stunell Word 13 03-19-2021 03:30 PM
Documents spontaneously become "read only" while I'm editing them Junebugsin Word 1 04-27-2018 06:39 PM
Enable Editing for "Protected View" documents automatically? (in order to run AutoOpen macros) Force a user to enable macros in Powerpoint? Hide sheets until the "enable" button is clicked copleyr PowerPoint 1 10-07-2016 01:15 AM
How do I delete the names under "Exceptions" when I use the "Restrict Editing" feature in Word? MengS Word 0 02-25-2015 02:57 PM
Enable Editing for "Protected View" documents automatically? (in order to run AutoOpen macros) Making a Macro "autoopen" Joshocom Word 1 03-16-2010 05:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:50 AM.


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