Forum Discussion
Isaac_Richards
Apr 25, 2022Copper Contributor
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 pu...
HansVogelaar
Apr 25, 2022MVP
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.
- Isaac_RichardsApr 25, 2022Copper ContributorI 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?
- HansVogelaarApr 25, 2022MVP
Sorry, no.
- Isaac_RichardsApr 25, 2022Copper ContributorAt least I know now. Thanks for your time.