Unable to make macro enabled workbook a Trusted Document because of Microsoft Excel Security Notice

I've been making Macros for excel for a few years.  I recently make 2 workbooks with macros for a couple of departments at work.  I made a 3rd macro workbook that opens the other 2 as read-only to pull data from them then close them.  Each time they are opened, the Microsoft Excel Security Notice window is displayed, preventing you from doing anything until enabling content.  Sometimes when opening a macro workbook, this window appears and sometimes the banner appears.  I'm aware that the banner makes the workbook a Trusted Document and that you can make it a Trusted Document if you go to File, Security Warning dropdown and Enable All Content, however you can't do either of those when the Security Notice window is displayed regardless of weather you choose to Disable/Enable/close the window.  I'm not trying to automatically enable all macros or anything like that.  I just want to know how to make a workbook a Trusted Document.  I've looked in all the settings multiple times and searched through various forums on the internet and found nothing helpful.