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

%3CLINGO-SUB%20id%3D%22lingo-sub-3293888%22%20slang%3D%22en-US%22%3EUnable%20to%20make%20macro%20enabled%20workbook%20a%20Trusted%20Document%20because%20of%20Microsoft%20Excel%20Security%20Notice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293888%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20making%20Macros%20for%20excel%20for%20a%20few%20years.%26nbsp%3B%20I%20recently%20make%202%20workbooks%20with%20macros%20for%20a%20couple%20of%20departments%20at%20work.%26nbsp%3B%20I%20made%20a%203rd%20macro%20workbook%20that%20opens%20the%20other%202%20as%20read-only%20to%20pull%20data%20from%20them%20then%20close%20them.%26nbsp%3B%20Each%20time%20they%20are%20opened%2C%20the%20%3CSTRONG%3E%3CEM%3EMicrosoft%20Excel%20Security%20Notice%3C%2FEM%3E%3C%2FSTRONG%3E%20window%20is%20displayed%2C%20preventing%20you%20from%20doing%20anything%20until%20enabling%20content.%26nbsp%3B%20Sometimes%20when%20opening%20a%20macro%20workbook%2C%20this%20window%20appears%20and%20sometimes%20the%20banner%20appears.%26nbsp%3B%20I'm%20aware%20that%20the%20banner%20makes%20the%20workbook%20a%20Trusted%20Document%20and%20that%20you%20can%20make%20it%20a%20Trusted%20Document%20if%20you%20go%20to%20File%2C%20Security%20Warning%20dropdown%20and%20Enable%20All%20Content%2C%20however%20you%20can't%20do%20either%20of%20those%20when%20the%20Security%20Notice%20window%20is%20displayed%20regardless%20of%20weather%20you%20choose%20to%20Disable%2FEnable%2Fclose%20the%20window.%26nbsp%3B%20%3CSTRONG%3E%3CEM%3EI'm%20not%20trying%20to%20automatically%20enable%20all%20macros%20or%20anything%20like%20that.%26nbsp%3B%20I%20just%20want%20to%20know%20how%20to%20make%20a%20workbook%20a%20Trusted%20Document.%3C%2FEM%3E%3C%2FSTRONG%3E%26nbsp%3B%20I've%20looked%20in%20all%20the%20settings%20multiple%20times%20and%20searched%20through%20various%20forums%20on%20the%20internet%20and%20found%20nothing%20helpful.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Isaac_Richards_0-1650890330306.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F366548iEC84CE191150A1A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Isaac_Richards_0-1650890330306.png%22%20alt%3D%22Isaac_Richards_0-1650890330306.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3293888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293939%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20macro%20enabled%20workbook%20a%20Trusted%20Document%20because%20of%20Microsoft%20Excel%20Security%20Not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293939%22%20slang%3D%22en-US%22%3EAt%20least%20I%20know%20now.%20Thanks%20for%20your%20time.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293931%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20macro%20enabled%20workbook%20a%20Trusted%20Document%20because%20of%20Microsoft%20Excel%20Security%20Not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293931%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1372576%22%20target%3D%22_blank%22%3E%40Isaac_Richards%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20no.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293921%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20macro%20enabled%20workbook%20a%20Trusted%20Document%20because%20of%20Microsoft%20Excel%20Security%20Not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293921%22%20slang%3D%22en-US%22%3EI%20appreciate%20the%20response%2C%20however%20this%20is%20not%20an%20option%20for%20me.%20I%20am%20not%20an%20admin%20for%20our%20network%20and%20there%20is%20next%20to%20zero%20chance%20the%20admins%20will%20be%20willing%20to%20change%20the%20network%20security%20setting%20just%20to%20make%20my%20project%20less%20of%20a%20bother%20to%20use.%20Do%20you%20know%20if%20there%20is%20a%20way%20to%20trust%20a%20specific%20document%20when%20the%20Security%20Notice%20shows%20up%20instead%20of%20a%20location%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3293902%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20macro%20enabled%20workbook%20a%20Trusted%20Document%20because%20of%20Microsoft%20Excel%20Security%20Not%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3293902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1372576%22%20target%3D%22_blank%22%3E%40Isaac_Richards%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%20the%20following%20(each%20user%20will%20have%20to%20do%20this)%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20File%20%26gt%3B%20Options%20%26gt%3B%20Trust%20Center%20%26gt%3B%20Trust%20Center%20Settings...%20%26gt%3B%20Trusted%20Locations.%3C%2FLI%3E%0A%3CLI%3ETick%20the%20check%20box%20'Allow%20trusted%20locations%20on%20my%20network%20(not%20recommended)'.%3C%2FLI%3E%0A%3CLI%3EClick%20'Add%20new%20location...'%3C%2FLI%3E%0A%3CLI%3EAdd%20the%20folder%20containing%20the%20macro%20workbook%20as%20a%20trusted%20location.%3C%2FLI%3E%0A%3CLI%3EOK%20your%20way%20out.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

Isaac_Richards_0-1650890330306.png

 

4 Replies

@Isaac_Richards 

Try the following (each user will have to do this):

  • Select File > Options > Trust Center > Trust Center Settings... > Trusted Locations.
  • Tick the check box 'Allow trusted locations on my network (not recommended)'.
  • Click 'Add new location...'
  • Add the folder containing the macro workbook as a trusted location.
  • OK your way out.
I appreciate the response, however this is not an option for me. I am not an admin for our network and there is next to zero chance the admins will be willing to change the network security setting just to make my project less of a bother to use. Do you know if there is a way to trust a specific document when the Security Notice shows up instead of a location?