Enable Content Security Warning

[Techsupport13]

Is there a way to automatically enable content on every workbook? The instructions I find show to turn off protected view but even after doing that I have to enable content once on each workbook that I open. Other information shows to change the settings on the message bar but it never explains if that is just doesn't show the message or if it allows the content as well. We use Excel 2013 & 2016 and we don't want to see "enable content" warnings but we do want to see the prompt to update links (don't want that automatic). Thanks

 

[Jaafar Tribak]

Is there a way to automatically enable content on every workbook? The instructions I find show to turn off protected view but even after doing that I have to enable content once on each workbook that I open. Other information shows to change the settings on the message bar but it never explains if that is just doesn't show the message or if it allows the content as well. We use Excel 2013 & 2016 and we don't want to see "enable content" warnings but we do want to see the prompt to update links (don't want that automatic). Thanks

Are we talking about one workbook ? You could create a small addin and run from it some vba code that automatically clicks the "Enable content" whenever that specific workbook is being opened.. (If the workbook is being used by different machines, you will have to have the addin installed in each computer)

 

[Techsupport13]

Jaafar, this is many different workbooks used by several employees. At this point it looks like if I turn off Protected view each person has to click "enable content" once per workbook and from then on they do not see that warning. At this point I am guessing that is just how it works.
Carmen