Macros have been disabled. Enable content work-around

[Stuepef]

I have a spreadsheet that has numerous macros within it across multiple sheets. I send this spreadsheet to others outside of my company, but the "Macros have been disabled. Enable Content" warning always shows up when the spreadsheet is first opened. I understand the security measures, but is there a way to always enable the content without changing the macro settings within the spreadsheet? The macros/content needs to be enabled for the spreadsheet to function properly and want to eliminate users needing to click the enable content button in order to use the spreadsheet, is this possible?

 

[Logit]

.
I could be wrong, but if a user does not have macros enabled in their copy of Excel to begin with, you can't create a macro that would enable macros.

This resource explains how you can have the user enable macros without going to the Excel settings but .... I personally don't know if it's worth the effort. Of course
I'm familiar with Excel Settings and don't have a problem accessing that area of Excel to enact changes.

https://wellsr.com/vba/2017/excel/macro-to-enable-trust-access-to-the-VBA-project-object-model/

This resource has not been tested by me.